Overview
All the featured macros of Advanced Tables for Confluence offer many formatting options such as applying date formats, setting languages, performing calculations on numeric columns and many more. This section explains how to leverage these table formatting options for a better readability.
Consider Monthly temperatures table, for which you want to perform 'Max', 'Min' and 'Average' operation on the columns and set background colors.
...
Define these parameters/values
Column settings > Formatting > Column Styles (1 2 3 4) | background:lightgrey background:lightblue background:lightyellow background:lightblue |
Column settings > Formatting > Column type (1 2 3 4) | String (S) Numeric and float values (F) Numeric and float values (F) Numeric and float values (F) |
Column settings > Formatting > Total type (1 2 3 4) | Max Min Avg Max Min Average |
| Column settings > Numbering & Totaling > Insert auto number column | On |
| Column settings > Numbering & Totaling > Auto total numeric columns | On |
Screenshot
Example result
| Info |
|---|
The same configurations, as shown above, can be set up for Advanced Tables for Confluence - CSV Table, JSON Table, JQL Table, and Attachment Table macros. |
...
| Child pages (Children Display) |
|---|
- Visit our full list of product examples for additional inspiration!