Overview

The macros within the Advanced Tables for Confluence add-on support a columnTypes parameter which allow you to control how the data in a given column will be treated and formatted. Each columnType can contain a formatting directive that indicates how the value should be displayed.

columnTypes Value	Description	Formatting
.	Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '.'
:	Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by ':'
-	Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'
/	Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'
C	Currency or similar where it is a float value with pre or post characters
CC	C with comma as decimal separator (available since 5.1.0)
D	Date in the browser date format. See Advanced Date Sorting for more information.
E	Emotions or other HTML elements (available since 5.0.0)
F	Float (since 5.1.0, this may contain a comma numeric separator)	f"0,0.0000"
FC	Float with a comma used as a decimal separator and a period used as a numeric separator (available since 5.1.0)
H	Indicates to hide the column.
I	This is a numeric field without a fractional component (also known as a "whole number").
S	This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters
X	Indicates to exclude this column from user selectable sorting