Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

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 Name

Any of the following:

  • Advanced Tables - CSV Table
  • Advanced Tables - Table Plus
  • Advanced Tables - Attachment Table
Macro Syntax

Any of the following:

  • {csv}
  • {table-plus}
  • {attachment-table}

...

Parameters/

...

Values 

This Auto Total row can be styled by setting the columnTypes parameter to:

Column settings > Numbering & Totaling > Auto total numeric columnsOn

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
languagetext
linenumberstrue
{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

Image RemovedImage Added

Other

...

examples

Visit our full list of product examples for additional inspiration!