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

Other examples

• Formatting options for date columns - 8.x
• Formatting options for numeric columns - 8.x

• Visit our full list of product examples for additional inspiration!