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.


Section


Column

Screenshot


Product Revenue.csv will address a problem with blanks for images.

Column

Message

Column

Exported CSV

Code Block
title
""," 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


Macro Browser Input

Select this Macro

...

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