Description
| Excerpt |
|---|
Adds This macro supports Common table capabilities. This adds column sorting and other attributes to one or more tablestables 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.
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
| Tip |
|---|
| title | Sort by clicking heading column |
|---|
|
| |
| Parameter | Default | Macro Browser Label | Description |
|---|
| multiple | true | Multiple table processing | All embedded tables are affected by the table properties specified. Set to false to only apply the table properties to the outer table. |
| Include Page |
|---|
| Common parameters |
|---|
| Common parameters |
|---|
|
1. Simple wiki table
| Section |
|---|
|
| 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 |
|---|
|
| 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}
|
|
|
Screenshots
*1 http://confluence.atlassian.com/confluence/renderer/notationhelp.action