Versions Compared

Old Version 7

changes.mady.by.user Bob Swift

Saved on

compared with

New Version Current

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive) (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Description

...

Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

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

  • 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

Tip
titleSort by clicking heading column
 
1. Simple wiki table
Section
bordertrue
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
bordertrue
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
bordertrue
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

Gallery

...

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 BrowserTable 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

(info) Click a column heading to toggle the sorting of that column.

Table plus
highlightColor#ffffec
rowStylesbackground:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;,
stylebackground-color:white;
autoNumbertrue


ParameterDefaultMacro Browser LabelDescription
multipletrueMultiple 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)
showLabelsfalse
spaces@self
showSpacefalse
sorttitle
operatorAND
cqllabel = "example" and label = "table_plus" and space = currentSpace ( )
labelsexample,table_plus

Other Macros

Below is a list of all other Macros available within this Add-on:

Filter by label (Content by label)
showLabelsfalse
spaces@self
sorttitle
typepage
cqllabel = "macro_home" and type = "page" and space = currentSpace ( )
labelsmacro_home

Additional References