Versions Compared

Old Version 13

changes.mady.by.user Betsy Walker

Saved on

compared with

New Version 14

changes.mady.by.user Betsy Walker

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Import Macro Repair

...

Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separator  | 

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

Basic Use

This macro can be deployed using one of the following methods:

Selected from the Macro BrowserTable Plus
Markup Shortcut{table-plus}

Screenshot

Image Added

Parameters

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

Table plus
highlightColor#ffffec
sortColumn1
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

...

Section
bordertrue
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
bordertrue
Column
Result
Table plus
sortColumn2
columnTypesS,I,I
autoNumbertrue
autoTotaltrue
sortIcontrue

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
bordertrue
Column
Result
Table plus
border0
highlightColorwhite
bgcolorsilver
columnTypesS,F,F,F
cellpadding10
cellspacing0
columnAttributesstyle="background:lightyellow; font-size:12pt; text-align: center;"
title'Monthly temperatures'
aligncenter
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

Gallery

...

Include Page
info:_CommonTableCapabilitiesParameters
info:_CommonTableCapabilitiesParameters

Examples

Filter by label (Content by label)
showLabelsfalse
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@3bbaf8c
sorttitle
showSpacefalse
operatorAND
labelsexample,table_plus
cqllabel = "example" and label = "table_plus" and space = currentSpace ( )

Other Macros

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

Filter by label (Content by label)
showLabelsfalse
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@3bbaf8c
sorttitle
typepage
labelsmacro_home
cqllabel = "macro_home" and type = "page" and space = currentSpace ( )

Additional References

 

Include Page
_SupportFooter
_SupportFooter

Include Page
_RightPanel
_RightPanel
_