Static Block formatting and style

  • 21 December 2021
  • 0 replies

Userlevel 3

The right formatting and style can make all the difference when presenting information. With the correct formatting, your data will reach your users in a more efficient way. Pigment has broad formatting and styling options including the specific cells, font style, value displaying, and colors within a Table, Metric or List. This article covers Static formatting, we have other articles for Conditional and Layout options



Where can you apply formatting?


Formatting can be applied to Lists, Metrics, and Tables.  When you have any of these blocks opened, you can find the Format button on the top towards the right side of the display panel. It is view specific, meaning the formatting from one view will not carry into another view.  You must also save it after applying any format for it to remain on view.  If you apply formatting and want to remove it, you can hit the Reset button next to the section, you’ll notice there is one for Style, Values and More options, each controls the formatting of that section. 



Formatting is stored at the view level, meaning any applied formatting must be saved to a view.  When adding blocks to a board, its important to select the correct view for the formatting to remain.


Formatting specific cells


You can also use all the display options for a specific cell.

Right-click on the cell you want to format and you will see all the options available.  If you want to select more than one cell, hold down Command / Control key and you can select more than one cell.  



Formatting headers


You can also format grid headers. 
When you click on a header it will select the corresponding column(s)/row(s). Right-click on it and select "Format cells". By default, this will be applied to all the selected cells except the header. To also apply this formating to headers, check the "Apply to: Grid header(s)" option.

Click on the image to expand the view


Formatting multiple Properties or Metrics at the same time 



Directly under the Static heading, you will see a drop-down, this will allow you to select multiple metrics or properties, depending on your view.  Once you have selected these, you can apply the same formatting across all selected values.  When you have more than 3 metrics, you will see a “Select All”, this will apply the formatting to all the metrics in that table.   When applying formatting on multiple metrics, it will not override any previously applied formatting at the cell level.  



Styling options


Background and Text color


If the chain is on, the text and the background will be harmonized. Click on the chain if you prefer a different customization

Cell borders


Click on the border you want to add

Font style


B for bold

I for italic



Values options


Number of decimals



Select the number of decimals to display

Value display


Display values in :
  • %
  • thousands
  • millions
  • billions
  • basis point




Text is added before the value





Text is added after the value

Zero value



Select value you want to show for zero.

Options available are 0 , - or (empty)

Negative value



Define how you want to display negative values.

Options available are, - or ()

Reverse signs


Activate the option to multiply by -1 all the items of a Metric.

1000 separator



Activate the option if you want to display a thousands separator.




0 replies

Be the first to reply!