| Div | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
On this page
|
Overview
This page outlines an example of how to style the Auto Total row for numeric columns using the CSV macro, Table Plus macro, or Attachment Table macro, which are part of the Advanced Tables for Confluence app app. This example assumes your data itself contains the formatting you want, such as comma separators and dollar signs. The instructions below will ensure that when you choose to have an Auto Total row, it too is similarly styled.
Macro
...
browser input
Select this
...
macro
| Macro Namename | Any of the following:
|
| Macro Syntaxsyntax | Any of the following:
|
...
Parameters/
...
values
This Auto Total row can be styled by setting the columnTypes parameter to:
| Column settings > Numbering & Totaling > Auto total numeric columns | On |
Column settings > Formatting > Column type (1 2 3) | s f"0,0" f"$0,0.00" |
| Info |
|---|
See Formatting Options options for Numeric Rowsnumeric rows for a full list of available formatting options. |
Screenshot
Wiki
...
markup input
For a table built using the CSV macro:
| Code Block | ||||
|---|---|---|---|---|
| ||||
{csv:output=wiki|autoTotal=true|columnTypes=s,f"0,0",f"$0,0.00"}
"Item","Units","Revenue"
"Kazoos","1,368","$4,074.25"
"Accordions","445","$222,500.63"
"Mandolins","2,296","$1,033,200.00"
{csv} |
...
Example result
Other
...
examples
Visit our full list of product examples for additional inspiration!