Column Types

On this page

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.

Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some macros, like the SQL and CSV macros, may automatically generate more precise types. When the default behavior is less than optimal for your situation, the columnTypes parameter can be set specifically. This describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry.

Example Use

Column types: S,I,F"0,0",F"$0,0.00"