Column types - 8.x
Overview
The macros within the Advanced Tables for Confluence app support a Column types parameter, which allows you to control how the data in a given column is 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.
Navigate to Column settings > Formatting > Column type in the respective macro to select from the list of available column types.
Type | Description | Sorting | Total Formatting | Data Formatting |
|---|---|---|---|---|
String (S) | Text string. This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters. | Alphabetic |
|
|
Integer (I) | Integer. This is a numeric field without a fractional component. | Numeric |
| |
Numeric or float values (F) | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. | Numeric |
| |
Numeric with data formatting (FF) | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. Forced formatting of data columns. If this column type is specified and the column contains any text or non-numeric value, this value is rendered as a zero (0). | Numeric | | |
Float with comma as decimal point (FC) | Numeric or float value and may contain numeric separators including a comma for decimal separator and a period for thousands separator. | Numeric |
| |
Currency (C) | Similar to F with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored. | Numeric |
| |
Currency with comma as decimal points (CC) | Similar to FC with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored. | Numeric |
| |
Date (M) | Date format in many popular formats. See Advanced Date Sorting for more information. This is the preferred date sorting type. | Date |
| |
Date in the browser date format (D) | Date in the browser date format. See Advanced Date Sorting for more information. The D type is available for compatibility with older releases - the M type is recommended. | Date |
|
|
Complex HTML elements like emotions or similar (E) | Emoticons or other HTML elements. | Alphabetic on the inner HTML value |
|
|
Exclude this column from user selectable sorting (X) | Indicates to exclude this column from user selectable sorting. | Disabled |
|
|
. | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '.'. | Numeric on each separated value |
|
|
: | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by ':'. | Numeric on each separated value |
|
|
- | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '-'. | Numeric on each separated value |
|
|
/ | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '/'. | Numeric on each separated value |
|
|
Hide the column (H) | Indicates to hide the column. |
|
|
|
Total formatting - option to format the total row in a user defined way. See Format the Auto Total Row for Numeric Columns.
Numeric data formatting - option to format the data rows in a user defined way for numeric columns. See Formatting Options for Numeric Columns.
Date data formatting - option to format the data rows in a user defined way for date columns. See Formatting Options for Date Columns.
Need support? Create a request with our support team.