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.
...
- Data filtering - filter table data by selecting the required value from the drop-down list under each column. Available from 8.3.0 version. Retains the row and column styles after filtering data (available since 8.2.0 version).
- Column sorting - sort a column by clicking on the column heading. Clicking again reverses the order.
- Data specific sorting - sort columns according to the type of data (text, numbers, dates, and so on). Click column heading to sort. See the Column types parameter for more information about supported data types.
- Column selection - show or hide specific columns using names or numbers.
- Download and export tables - download tables or export as an attachment as a CSV file (available from 8.1.0 version). Specify user-defined file delimiter (available since version 8.2.0) for the table view to be downloaded or exported.
- Auto sort of selected column - automatically sort the table based on a specific column name or number before rendering the table on the page.
- Auto numbering of rows - automatically add a leading column that contains the row number.
- Auto totaling of numeric columns - automatically total the numeric columns specified in Column types. See Column types for more information.
- Row highlighting on mouseover - highlight a row when the mouse goes over any row element for non-heading rows.
- Row styles - set CSS at the row level. Can override default Confluence styles to apply user-defined styles to each row cell directly. Available from 8.1.0 version
- Column styles - set CSS at the column level. Can override default Confluence styles to apply user-defined styles to each row cell directly. Available from 8.1.0 version
Column attributes - set HTML attributes for columns. Specify the required attributes in a comma-separated list where attributes for a column must be separated with double semi-colons (;;).
Info Certain attributes such as
style,class,colspan,rowspan, and so on, are rendered directly on the page. Other attributes are hidden from being displayed on the page but can be viewed from the page source (right-click the page and select View page source in most browsers).Table headers - show or hide table header rows. Depending on the number of header rows specified, the rows of the table are hidden. Available since 8.2.0 version.
Table attributes - set table class, table style, and row styles. See Style Table Columns.
In the macro editor window, all these common capabilities are logically grouped into various tabs based on the functionality for easy access and styling.
...
Macros that include this support
- Table Plus macro
- CSV (Comma Separated Values) macro
- Attachment Table macro
- JSON Table macro
- SQL macro
- SQL File macro
- SQL Query macro
Common parameters
| Include Page | ||||
|---|---|---|---|---|
|
...
| Panel | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| |||||||||
|
