On this page
- 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 Styling Table Columns
Macros that include this support
- Attachment Table Macro
- CSV (Comma Separated Values) Macro
- Excel Macro
- JSON Table Macro
- SQL Macro
- SQL-file Macro
- SQL-query Macro
- Table Plus macro
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.
|Parameter||Default||Macro Browser Label||Description|
Number of rows to be considered as heading rows. Heading rows do not participate in column sorting.
Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.
|true||Enable column sorting||Set to false to disable sorting.|
|true||Enable row highlighting on mouse over||As the mouse moves over a table row, the row will be highlighted by default. Set to false to stop this behavior.|
|Auto sort column||The table can be auto sorted before it is displayed by any valid column name or number provided by this parameter. No auto sorting will be done if this value is not provided or is invalid. A column number is a 1-based count of columns (excluding auto number column).|
|false||Sort descending||If sortColumn is used, this determines the order of the sort that is automatically done before display.|
|Sort tip on mouse over||Text displayed when mouse is over a sortable column. Normally, this value is Click to sort or equivalent translation.|
|false||Show sort icon||Use true to include a sort icon in the first heading row for sortable columns. An icon will show for the last column sorted indicating the direction the column was sorted.|
|lightgoldenrodyellow||Highlight color||Color of row when mouse is over a row element. See Web colors for how to specify.|
|false||Auto number on each row||Use true to show an additional column that show row number for each data row.|
|false||Auto number sort||Use true to enable the auto number column to be sortable. This will retain the original data row count even after row sorting.|
|false||Auto total row||Use true to append a row to the end of the table that will contain totals of all numeric columns.|
|Column types||Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some macros, like the SQL and CSV macros, may automatically generate more precise types. When the default behavior is less than optimal for your situation, the columnTypes parameter can be set specifically. This describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry.|
|columnCalculations||Column calculations||When an auto total row is selected, this parameter can be used to customize the calculation or text that is shown on the total row. By default, all numeric fields, as specified by column types, are totaled. By specifying a comma separated list of calculation requests, the behavior can be modified using special values for the corresponding column.|
|Table row styles|
A comma separated list of styles. Each style is made up of one or more properties. The first is applied to all heading rows determined by the heading parameter. The remaining styles are applied to the remaining rows in order with repetition as necessary. Row styles are applied to the table row and participate with other CSS properties to determine the look of an element. In particular, some properties may be overridden by table or element styles or classes.
Example: , background:lightyellow, background:lightblue
|true||Retain row style order after sorting|
When selected, the row styles correspond to the order the rows are displayed on the screen. When not selected, the original style given to a row is retained not matter where the row lands after sorting.
Comma separated list of styles. Each style is made up of one or more CSS properties (semi-colon separated). The styles are applied to columns in sequence. If a column is skipped, supply a comma before adding the next columns style. A style can be reused for subsequent column(s) by referring to it using a 1-based numeric reference. Column styles are applied to the table column and participate with other CSS properties to determine the look of an element. In particular, some properties may be overridden by table, row, or element styles or classes.
Example: background:lightyellow, background:lightblue,1,2,1,2
|Column attributes||A comma separated list of values used to modify cell attributes for all cells in a column. The position in the comma separated list corresponds to the column that the values apply to. Each value is a double semi-colon list of attributeName=value pairs that will be applied to the column cells.|
|true||Enable heading attributes||Any column attributes provided will be applied to the all column rows including heading rows. Use false to have the column attributes apply only to data rows.|
|@default||Table class||Sets the class of the table. Normally, it will be confluenceTable. Use a blank (one or more spaces) value to not have any table class.|
|Table style||Style attributes can be set. For example: font-style:italic; background:lightblue;.|
|Table width||In pixels or %. Recommend using style settings instead.|
|Table border width||In pixels. Set class to blank also. Recommend using style settings instead.|
which renders as:
Find answers from the community.
Ask a question to the community.
Log a request with our support team.