On this page
Overview
A number of macros that produce or modify tables share common capabilities as described below. A JavaScript enabled browser is required to enable most of these capabilities.
Capabilities
- Column sorting - sort a column by clicking on column heading. Clicking again will reverse the order.
- Data specific sorting - see the columnTypes parameter
- Column selection - hide columns
- Auto sort of selected column
- Auto numbering of rows - ability to automatically add a leading column with the data row count.
- Auto totaling of numeric columns
- Row highlighting on mouseover - the row is highlighted when mouse goes over any row element for non-heading rows
- Row styles - ability to set CSS at the row level
- Column styles - ability to set CSS at the column level
- Column attributes - ability to set the display attributes (color, font) on a column basis
- Table attributes - set table class, table style, and row styles - See Style Table Columns
Macros that include this support
- Table Plus Macro
- CSV Macro
- Attachment Table Macro
- JSON Table Macro
- Excel Macro
- SQL Macro
- SQL-file Macro
- SQL-query Macro
Common parameters
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.
Date sorting
Examples
{table-plus:columnTypes=S,-,.|autoNumber=true|sortColumn=3 |columnAttributes=style="text-align:center;", ,style="background:yellow; font-size:14pt;"} || Name || Phone || TCP || | John | 555-1234 | 192.168.1.10 | | Mary Lou | 555-2134 | 192.168.1.12 | | Bob | 555-4527 | 192.168.1.9 | {table-plus}
which renders as:
Styling guide
Table styling can be done utilizing the common table capabilities of several Bob Swift Atlassian apps including Advanced Tables for Confluence, SQL for Confluence, and others.
For creative inspiration when styling your own Confluence Tables (including live examples) visit our Styling Guide for Tables.