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.
...
Table plus
Tabs
Macro Editor Label
Default
Description
Macro Parameter
Table settings
Formatting
Table id
auto generated
Enter an ID for the table. Can be referenced for use in macros like the chart macro or Javascript.
id
Table class
@default
Enter a class to set the styles for the table. Sets 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
Enter CSS styles to be used for the table. For example: font-style:italic; background:lightblue;.
style
Table width
Enter width of the table in pixels or %. Recommended to use Table style instead.
width
Border width
Enter the border width for the table in pixels. Set class to blank also. Recommended to use Table style instead.
border
Advanced settings
Enable download and export as attachment
Off
Enable this option to allow 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. Available since 8.1.0 version.
Note
Only those users that have the permission to add attachments to the page are allowed to export tables.
If enabled, select a character from the drop-down to be used as a delimiter for the data to be downloaded or exported. The options provided are:
Comma: Default value used as the delimiter.
Tab
Semicolon
Space
Other: Select this option to specify a character that is not in the drop-down, to be used as a delimiter. Enter a single character to be used as a delimiter in the adjoining text box. The downloaded or exported file contents are separated with this character.
Valid only if Enable download and export as attachment is enabled. Available since 8.2.0 version.
allowExport
Display data filter
Off
Turn Enable this toggle Onoption to display a filter panel above the table. Panel contains a text box to enter the required search criteria and buttons: Filter to proceed with the search, and, Clear to clear the box to start a new search. Can use regular expressions. To know more about regular expressions, refer to thethis article. Available since 8.1.0.
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=valuepairs that will to be applied to the column cells.
columnAttributes
Numbering & Totaling
Insert auto number column
Off
Turn Enable this parameter Onoption to show an additional column that show row number for each data row.
autoNumber
Auto number column styles
Enter the CSS styles to be applied on the auto number column if Insert auto number column is enabled.
autoNumberColStyles
Enable sorting on auto number column
Off
Turn this toggle On to Enable this option to enable the auto number column to be sortable. This will retain retains the original data row count even after row sorting.
autoNumberSort
Apply column attributes to header rows
On
Any Disable this option to have the column attributes apply only to data rows. By default, any column attributes provided will be are 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 cells
Off
Turn Enable this toggle Onoption to make the styles in the Column styles field (Formatting tab) persistfor the specified columns. Available since 8.1.0.
Auto total numeric columns
Off
Turn Enable this parameter Onoption to append a row to the end of the table that will contain contains the totals of all numeric columns.
autoTotal
Sorting
Enable column sorting
On
Turn Disable this parameter Offoption to disable sorting.
enableSorting
Automatically sort this column
The table can be auto sorted
Enter a valid column name or number to automatically sort the table before it is displayed
by any valid column name or number provided by this parameter
. No
auto
automatic sorting
will be
is done if this value is not provided or is invalid. A column number is
a 1-based count of columns (excluding auto number column)
indexed beginning at "1" and excludes any auto-numbered columns.
sortColumn
Automatically sort in descending order
Off
If sortColumn is used, this determines the order of the sort that is automatically done before display.
Enablethis optionto sort in the descending order, to bedone automatically, before display. This works only ifAuto sort column is specified.
sortDescending
Off
Turn Enable this parameter On optionto include a sort icon in the first heading row for sortable columns.An icon appears is displayed for the last column sorted indicating the direction in which the column was sorted.
sortIcon
Sort tip text
Text Enter the text to be displayed when the mouse is over a sortable column. Normally, this value is Example: Click to sort or an equivalent translation.
sortTip
Row formatting
Data rows
Row styles
Click Start Styling to format your table rows.
Each of the rowstyles 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.
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 rows
1
Number Enter the number of rows to be considered as heading rows. Heading rows do are not participate considered in column the sorting of columns.
heading
Header row styles
A Enter a comma-separated list of CSS styles (similar to Row styles) that is applied on the header row.
rowStyles
Hide header rows
Off
Enable this option to hide the table header rows as specified in Number of header rows. By default, all header rows are shown.
Note
This option is not applicable for the Attachment Table macro.
If Number of header rows is 0, the header row is not displayed regardless whether this option is enabled or not.
Any styles given for header rows are ignored if this option is enabled.
hideHeader
Number of footer rows
0
Number Enter the number of rows to be considered as footing rows. Footing rows do are not participate considered in column the sorting of columns.
footing
Auto total row styles
Enter the CSS styles to be applied on the auto total row if Column settings > Numbering and totaling > Auto total numeric columns is enabled.
autoTotalRowStyle
Advanced settings
Retain row style order after re-sorting
On
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.
retainRowStyleOrder
Apply Row styles to data rows
Off
Turn this toggle On to make the styles in the Row styles field (Data rows tab) persistfor the specified columns. Available since 8.1.0.
Enable row highlighting on mouse over
On
As the mouse moves over a table row, the row is highlighted by default. Turn this parameter Off to stop this behavior.
enableHighlighting
Highlight color
lightgoldenrodyellow
Color of row when mouse is over a row element. See Web Colors for instructions on how to specify this.
