Overview

Numeric values within total rows (of numeric table columns) can be formatted to look like currency, percentages, times, or plain numbers with decimal places, thousands, and abbreviations. This functionality was introduced in version 6.2 of the Advanced Tables for Confluence app.

Version 6.4 extended the support to provide the ability to force the format on the view of the data rows (Numeric with data formatting (FF) and Date (M) formats). The actual data is not changed, just how it is displayed. This helps to keep the data looking consistent even if the provided data is not. The Column types parameter is used to specify what type of formatting is done. 

Usage

The formatting options listed on this page can be defined through the Column types parameter within the following macros:

• Table Plus macro
• CSV Table macro
• Attachment Table macro
• JSON Table macro
• SQL macro
• SQL File macro
• SQL Query macro

Screenshot

Formatting options

Examples

Formatting the Auto Total row for numeric columns example shows how numeric values can be converted in total rows.

Internationalization (Language)

The format can be automatically switch to support various international differences by adding a language parameter to the format.

 For example: