Static Block formatting and style

  • 21 December 2021
  • 2 replies
  • 206 views

Userlevel 3
Badge

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

Prefix

 

 

Text is added before the value

 

Suffix

 

 

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.

 

 

 


2 replies

How can I format a header without applying that same formatting to the corresponding column/ row? for example, I can see the "Apply to: Grid header(s)" option, but there’s no option to solely apply formatting to an individual header (like how you can apply format to an individual cell). Thank you!

Userlevel 4
Badge +4

How can I format a header without applying that same formatting to the corresponding column/ row? for example, I can see the "Apply to: Grid header(s)" option, but there’s no option to solely apply formatting to an individual header (like how you can apply format to an individual cell). Thank you!

 

Hi Megan, at the moment you can do that in two steps: 

  • format the column, including the header
  • format again the column (back to white for example), without the header

Reply