Versions Compared

Key

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

Name

Table-plus Macro

Download

See TBL

Issue Tracking

http://studio.plugins.atlassian.com/browse/TBL

Description

 

Excerpt

Adds column sorting and other attributes to one or more tables

found in the body of the macro. The tables can be produced by wiki markup or other means. Clicking on a column heading will cause that column to be sorted. Clicking again will reverse the order. Note that the excel, csv, or sql macros already have most of these capabilities.

Documentation

  • Check the Notation guide

...

Tip
titleSort by clicking heading column
 
1. Simple wiki table
Section
bordertrue
Column
Result
Wiki Markup
{table-plus}
|| || January || February || March || April ||
| Max | 37.5 | 32.7 | 28.0 | 25.3 |
| Min | 31.3 | 26.8 | 25.1 | 18.7 |
{table-plus}
Column
Source
No Format

{table-plus}
|| || January || February || March || April ||
| Max | 37.5 | 32.7 | 28.0 | 25.3 |
| Min | 31.3 | 26.8 | 25.1 | 18.7 |
{table-plus}

...

Section
bordertrue
Column
Result
Wiki Markup
{table-plus:autoTotal=true|autoNumber=true|sortColumn=2|sortIcon=true|columnTypes=S,I,I}
|| Fish Type || 2004 || 2005 ||
|| Herring | 9500 | 8300 ||
|| Salmon | 2900 | 4200 ||
|| Tuna | 1500 | 1500 ||
{table-plus}
Column
Source
No Format

{table-plus:autoTotal=true|autoNumber=true|sortColumn=2|sortIcon=true|columnTypes=S,I,I}
|| Fish Type || 2004 || 2005 ||
|| Herring    | 9500  | 8300 |
|| Salmon     | 2900  | 4200 |
|| Tuna       | 1500  | 1500 |
{table-plus}

...

Section
bordertrue
Column
Result
Wiki Markup
{table-plus:border=0|align=center|cellspacing=0|cellpadding=10|class=''|title='Monthly temperatures'|highlightColor=white|bgcolor=silver|columnTypes=S,F,F,F|columnAttributes=style="background:lightyellow; font-size:12pt; text-align: center;"}
*2006*
|| Month || Max || Min || Average ||
| January | 25.5 | *6.3* | 15.9 |
| February | 32.4 | 12.8 | 22.6 |
| March | 44.6 | 24.5 | 34.6 |
| April | 59.7 | 37.1 | 48.4 |

*2007*
|| Month || Max || Min || Average ||
| January | 23.4 | *6.1* | 14.9 |
| February | 31.4 | 12.9 | 21.8 |
| March | 43.6 | 24.5 | 34.6 |
| April | 58.7 | 36.1 | 45.4 |
{table-plus}
Column
Source
No Format

{table-plus:border=0|align=center|cellspacing=0|cellpadding=10|class=''|title='Monthly temperatures'|
            highlightColor=white|bgcolor=silver|columnTypes=S,F,F,F|
            columnAttributes=style="background:yellow; font-size:12pt; text-align: center;"}

*2006*
|| Month || Max || Min || Average ||
| January | 25.5 | *6.3* | 15.9 |
| February | 32.4 | 12.8 | 22.6 |
| March | 44.6 | 24.5 | 34.6 |
| April | 59.7 | 37.1 | 48.4 |

*2007*
|| Month || Max || Min || Average ||
| January | 23.4 | *6.1* | 14.9 |
| February | 31.4 | 12.9 | 21.8 |
| March | 43.6 | 24.5 | 34.6 |
| April | 58.7 | 36.1 | 45.4 |
{table-plus}

Open Issues with this component

Jira Issues
columnstype,key,summary,reporter,assignee,priority,status
url

...

https://

...

bobswift.

...

atlassian.net/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?jqlQuery=project+%3D+TBL+AND+status+%3D+Open+and+%28component+in+%28table-plus%29+or+component+not+in+%28csv%29%29+ORDER+BY+priority+DESC&tempMax=1000

Screenshots

Gallery

...

*1 http://confluence.atlassian.com/confluence/renderer/notationhelp.action