Description
This macro supports Common table capabilities. This 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.
Parameters
| 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| Table plus |
|---|
| January | February | March | April |
|---|
Max | 37.5 | 32.7 | 28.0 | 25.3 | Min | 31.3 | 26.8 | 25.1 | 18.7 |
|
|
| 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}
|
|
|
2. Simple totals
| Section |
|---|
|
| Column |
|---|
Result| Table plus |
|---|
| sortColumn | 2 |
|---|
| columnTypes | S,I,I |
|---|
| autoNumber | true |
|---|
| autoTotal | true |
|---|
| sortIcon | true |
|---|
| Fish Type | 2004 | 2005 |
|---|
Herring | 9500 | 8300 |
|---|
Salmon | 2900 | 4200 |
|---|
Tuna | 1500 | 1500 |
|---|
|
|
| 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}
|
|
|
3. Change how table looks
| Section |
|---|
|
| Column |
|---|
Result| Table plus |
|---|
| border | 0 |
|---|
| highlightColor | white |
|---|
| bgcolor | silver |
|---|
| columnTypes | S,F,F,F |
|---|
| cellpadding | 10 |
|---|
| cellspacing | 0 |
|---|
| columnAttributes | style="background:lightyellow; font-size:12pt; text-align: center;" |
|---|
|
| | align | center |
|---|
| title | 'Monthly temperatures' |
|---|
| align | center |
|---|
| class | '' |
|---|
| 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 |
|
| 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