Versions Compared

Key

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

...

Tip
titleAvailable with version 7.2.0 on Server only

 See Release Notes notes 7.2.


will address a problem with blanks for images.
Section


Column

Screenshot

Image RemovedImage Added


Exported CSV

Column
Code Block
titleProduct Revenue.csv
""," Product "," On Plan "," Revenue "
"1"," A ","  ","$325,100"
"2"," D ","  ","$315,850"
"3"," C ","  ","$250,420"
"4"," B ","  ","$98,650"
"5"," E ","  ","$79,010"
"","","","$1,069,030"
Jira Legacy
TBL-524TBL-524

 

Message

Image Added


Macro Browser Input

Select this Macro

...

Allow exportselected
Table idProduct Revenue

Auto number on each row

selected

Auto total row

selected

Sort descending

selected

Auto sort column

3

Column types

S,E,I

Screenshot

Image Removed

 Image Added


Wiki Markup Input

Code Block
languagetext
linenumberstrue
{table-plus:allowExport=true|id=Product Revenue|autoNumber=true|autoTotal=true|sortDescending=true|sortColumn=3|columnTypes=S,E,FF"$0,0"}
|| Product || On Plan || Revenue ||
| A | (/) | 325100 |
| D | (/) | 315850 |
| C | (x) | 250420 |
| B | (/) | 98650  |
| E | (x) | 79010  |
{table-plus}

 

Example Result

...

Exported CSV

The attachment Product Revenue.csv exported above, can be imported back to a Confluence page using the CSV Macro. This could be used for showing snapshots of tables that have been archived for a historical view. The following is like CSV macros with the attachment on this page.

As Text


Code Block
titleProduct Revenue.csv
"","Product","On Plan","Revenue"
"1","A","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$325,100"
"2","D","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$315,850"
"3","C","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/error.png","$250,420"
"4","B","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/check.png","$98,650"
"5","E","https://examplegear.com/s/en_GB/6214/6860359b26f1e8cc7164bebdad0e2f04c128c291.1/_/images/icons/emoticons/error.png","$79,010"
"","","","$1,069,030"


With CSV Macro As Is


Csv
script^Product Revenue.csv


With CSV Macro With A Few Parameters To Make It Look More Like the Original


Csv
outputwiki
footingAugments,
columnTypesI,S,E,C
footing1
script^Product Revenue.csv
augments,,!%3%!

The following parameters were used in the CSV macro shown above:


Select this Macro

Macro NameCSV
Macro Syntax{csv}

Define these Parameters/Values

Output formatwiki
Footing rows1

Augments to data row values

, , !%3%!

Augments to footing row values

, , Total

Location of data

^Product Revenue.csv

Column types

I,S,E,C

Other Examples

Visit our full list of product examples for additional inspiration!

 

Include Page_SupportFooter_SupportFooter