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. |
Overview
The following parameters are part of our common table capabilities that are available to many macros that produce or modify tables.
Click a column heading to toggle the sorting of that column.
1. Simple wiki table
Result
|
January |
February |
March |
April |
|---|---|---|---|---|
Max |
37.5 |
32.7 |
28.0 |
25.3 |
Min |
31.3 |
26.8 |
25.1 |
18.7 |
Source
{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
Result
Fish Type |
2004 |
2005 |
|---|---|---|
Herring |
9500 |
8300 |
Salmon |
2900 |
4200 |
Tuna |
1500 |
1500 |
Source
{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
Result
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 |
Source
{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
| There are no images attached to this page. |
