Auto-number rows and auto-total numeric columns - 8.x

Owned by Former user (Deleted)
Last updated: Nov 13, 2020 by Smita Nair
2 min read

Overview

This page demonstrates how to use the Table Plus macro, which is part of the Advanced Tables for Confluence app, to auto-number rows and auto-total numeric columns using the following table:

Macro browser input

Select this macro

Macro NameAdvanced Tables - Table Plus
Macro Syntax{table-plus}

Parameters/values

Column settings > Formatting > Column type (1

2

3)

S

E

I

Column settings > Formatting >  > Column attributes (1

2

3)

style="text-align:center;"

style="text-align:center;"

style="background:lightyellow;text-align:right;"

Column settings > Numbering & Totaling > Insert auto number columnOn
Column settings > Numbering & Totaling > Auto total numeric columnsOn
Column settings > Sorting > Automatically sort in descending orderOn
Column settings > Sorting > Automatically sort by this column3
Row formatting > Advanced settings > Highlight colorlightgoldenrodyellow

Screenshot

Wiki markup input

{table-plus:autoNumber=true|autoTotal=true|sortDescending=true|sortColumn=3|columnTypes=S,E,I|columnAttributes=style="text-align:center;",style="text-align:center;",style="background:lightyellow;text-align:right;"|highlightColor=lightgoldenrodyellow}
|| Product || On Plan || Revenue ||
| A | (/) | 325100 |
| D | (/) | 315850 |
| C | (x) | 250420 |
| B | (/) | 98650  |
| E | (x) | 79010  |
{table-plus}

Example result


Note that columns are centered, rows are auto-numbered, and the Revenue column is auto-totalled. You can click a column heading to sort by that column.

Other examples

Visit our full list of product examples for additional inspiration!