Description
...
| Div |
|---|
|
On this page| Table of Contents |
|---|
| maxLevel | 1 |
|---|
| exclude | On this page |
|---|
| type | flat |
|---|
| separator | pipe |
|---|
|
|
Overview
| Excerpt |
|---|
The Table Plus macro adds advanced functions and formatting to Confluence tables, by: - Dynamically totaling numeric data.
- Dynamically numbering each table row.
- Defining the default sort order for the table.
- Highlighting a row when the user hovers the pointer over it.
- Using CSS to style the entire table or individual columns and rows.
|
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.
Documentation
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 |
|---|
|
| |
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}
|
|
|
2. Simple totals
| Section |
|---|
|
| 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}
|
|
|
3. Change how table looks
| 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}
|
|
|
Open Issues with this component
| Jira Issues |
|---|
| columns | type,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
...
Feature Video
| Include Page |
|---|
| Feature Video - Table Plus macro |
|---|
| Feature Video - Table Plus macro |
|---|
|
Basic Use
This macro can be deployed using one of the following methods:
| Selected from the Macro Browser | Table Plus |
|---|
| Markup Shortcut | {table-plus} |
|---|
In the body of the macro, insert a Confluence table as you normally would and edit the row and columns as needed. On rendering or preview, the table-plus macro will process the table to add the advanced capabilities according to the parameters specified on the macro.
Screenshot
Image Added
Parameters
Click a column heading to toggle the sorting of that column.
| Table plus |
|---|
| highlightColor | #ffffec |
|---|
| rowStyles | background:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;, |
|---|
| style | background-color:white; |
|---|
| autoNumber | true |
|---|
|
| 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. |
|
Common Parameters
| Include Page |
|---|
| info:_CommonTableCapabilitiesParameters |
|---|
| info:_CommonTableCapabilitiesParameters |
|---|
|
Examples
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| spaces | @self |
|---|
| showSpace | false |
|---|
| sort | title |
|---|
| operator | AND |
|---|
| cql | label = "example" and label = "table_plus" and space = currentSpace ( ) |
|---|
| labels | example,table_plus |
|---|
|
Other Macros
Below is a list of all other Macros available within this Add-on:
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| spaces | @self |
|---|
| sort | title |
|---|
| type | page |
|---|
| cql | label = "macro_home" and type = "page" and space = currentSpace ( ) |
|---|
| labels | macro_home |
|---|
|
Additional References