Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The parameters listed on this page are a part of our common table capabilities that are available in many macros that produce or modify tables.

Info

Click a column heading to toggle the sorting of that column.

Table plus


TabsMacro Editor LabelDefaultDescriptionMacro Parameter

Table settings

Formatting

Table idauto generatedTable ID can be referenced for use in macros (like the chart macro) or Javascript.id
Table class@defaultSets the class of the table. Normally, it is confluenceTable. Use a blank value (one or more spaces) to not have any table class.class
Table style
Style attributes can be set. For example: font-style:italic; background:lightblue;.style
Table width
In pixels or %. Recommendation is to use style settings instead.width
Border width
In pixels. Set class to blank also. Recommendation is to use style settings instead.border
Advanced settingsEnable download and export as attachmentOffEnables user to download or export the current view of the table as a CSV file. Downloads to the local file system. Exports as an attachment to the current page and is only available to users that have permission to add attachments to the page. When enabled, download and export icons are available to the right of the table. This is a new option starting with Advanced Tables 7.2, SQL 8.3, and Excel 6.3.allowExport
Display data filterOff

Turn this toggle On to display a drop-down list with unique column values under each column heading. By default, the None option is selected.

Select filter values in multiple columns to see a more specific row. Select None to display all rows for that column. As filters are applied on other columns, the display of information differs. Select None for all columns to show all rows for all columns. Available since 8.3.0. 

Note
  • Filters are applicable only for text based searches, and are not applicable on data in nested macros or nested tables currently.
  • This version of applying filters replaces the previous feature available since version 8.1.0. In the earlier version, a filter panel was displayed above the table and the search text box accepted regular expressions. From version 8.3.0, only column filters are available for tables.


Info

There is a known issue with the Display data filter parameter. When you select the drop-down for the first time, the column gets sorted though the list is not visible, and from the next click onwards, the list drops down displaying the unique values available in that column. This does not affect the working of the filters in any way.


displayDataFilter

Column settings

Formatting

Column styles

Click Start Formatting to format your table columns.

Each of the column styles is made up of one or more CSS properties (semi-colon separated). The styles are applied to the respective columns as provided in the editor window. A style can be reused for subsequent columns by using a numeric reference of the column. (For example, you want to reuse 3rd column style in 6th - use 3 as style value in column 6) 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

Note

When the Insert auto number column parameter is On, say you want to repeat a column style, use numeric reference of this column +1 in the intended column.

For example, to reuse 3rd column style in 6th when Insert auto number column is On - use 4 as style value in column 6.


columnStyles
Column type

Include Page
_ColumnTypes80
_ColumnTypes80

columnTypes
Total type

Include Page
_ColumnCalculations
_ColumnCalculations

columnCalculations
Column attributes

Click and select Show column attributes to view the respective columns attributes field in the editor. 

Specifies a comma separated list of values used to modify cell attributes for the respective column. Each value is a double semi-colon list of attributeName=value pairs that will be applied to the column cells.

columnAttributes
Numbering & Totaling

Insert auto number columnOff

Turn this parameter On to show an additional column that show row number for each data row.

autoNumber
Enable sorting on auto number columnOffTurn this toggle On to enable the auto number column to be sortable. This will retain the original data row count even after row sorting.autoNumberSort
Apply column attributes to header rowsOnAny column attributes provided will be applied to the all column rows including heading rows. Turn this parameter Off to have the column attributes apply only to data rows.enableHeadingAttributes
Apply Column styles to data cellsOffTurn this toggle On to make the styles in the Column styles field (Formatting tab) persist for the specified columns. Available since 8.1.0.
Auto total numeric columnsOffTurn this parameter On to append a row to the end of the table that will contain totals of all numeric columns.autoTotal
Sorting



Enable column sortingOnTurn this parameter Off to disable sorting.enableSorting
Automatically sort this 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).sortColumn
Automatically sort in descending orderOffIf sortColumn is used, this determines the order of the sort that is automatically done before display.sortDescending
OffTurn this parameter On to include a sort icon in the first heading row for sortable columns. An icon appears for the last column sorted indicating the direction the column was sorted.sortIcon
Sort tip text
Text displayed when mouse is over a sortable column. Normally, this value is Click to sort or equivalent translation.sortTip

Row formatting

Data rowsRow styles

Click Start Styling to format your table rows.

Each of the row styles is made up of one or more properties. Each style is applied to the respective row. 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

Note
  • These styles are applied to the data rows starting from the first row below the header and not to the header itself. 
  • A row style can be reused for subsequent rows by using a numeric reference of this row + 1. For example, to reuse 3rd row style in 6th - use 4 as style value in row 6.


row index
Header & Footer rows

Number of header rows1Number of rows to be considered as heading rows. Heading rows do not participate in column sorting.heading
Header row styles
A comma separated list of styles (similar to Row styles) that is applied on the header row.rowStyles
Number of footer rows0Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.footing
Advanced settings

Retain row style order after re-sortingOnWhen 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.retainRowStyleOrder
Apply Row styles to data rowsOffTurn this toggle On to make the styles in the Row styles field (Data rows tab) persist for the specified columns. Available since 8.1.0.
Enable row highlighting on mouse overOnAs the mouse moves over a table row, the row is highlighted by default. Turn this parameter Off to stop this behavior.enableHighlighting
Highlight colorlightgoldenrodyellowColor of row when mouse is over a row element. See Web Colors for instructions on how to specify this.highlightColor


...