Table-plus macro

Description

Adds column sorting and other attributes to one or more tablesfound 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

Parameters

In addition to the parameters listed below, this macro supports Common table capabilities.

• heading - Number of rows to be considered heading rows (default is 1 row). Specify heading=false or heading=0 to not show any heading lines. Heading rows do not participate in sorting.
• border - The border width in pixels. Defaults to normal table border width.
• width - The table width in pixels. Default is 100%.
• multiple - Default is true which means all tables found within the macro body are processed. Set multiple=false to only process the first table found. May need to be used if the table includes cells that are also tables.
• Other parameters - Other parameters, such as 'cellspacing' or 'cellpadding', are passed through to the html table markup for more advanced capabilities,
  or to override the default class.

Live Examples

1. Simple wiki table

{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}

2. Simple totals

{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}

3. Change how table looks

{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}

Screenshots

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