Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Div | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
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 This functionality was introduced in Version 6.2 of the Advanced Tables for Confluence add-on.
Version 6.4 extended the support to provide the ability to force the format on the view of the data rows. 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"Types parameter within the following Macros:
- CSV macro
- Table Plus macro
- Attachment Table macro
- JSON Table Macro
- SQL Macro
- SQL-query Macro
- SQL-file Macro
- Excel Macro
Screenshot
Formatting Options
Info | ||
---|---|---|
| ||
Advanced numeric formatting support is provided using javascript implemented by the TBLSORT with the help of the Numerals.js library (open source, MIT license). A summary of the relevant parts of the numerals.js documentation is repeated here. |
Table plus | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Numbers
Currency
Bytes
Percentages
Time
|
Examples
The following example shows how numeric values can be converted in total rows:
Include Page | ||||
---|---|---|---|---|
|
Include Page | ||||
---|---|---|---|---|
|