The following parameters are part of our common table capabilities that are available to many macros that produce or modify tables.
...
Table plus
Tabs
Macro Editor Label
Default
Description
Macro Parameter
Table settings
Formatting
Table id
auto generated
Table id can be referenced for use in macros (like the chart macro) or javascript.
id
Table class
@default
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.
class
Table style
Style attributes can be set. For example: font-style:italic; background:lightblue;.
style
Table width
In pixels or %. Recommend using style settings instead.
width
Border width
In pixels. Set class to blank also. Recommend using style settings instead.
border
Advanced settings
Enable download and export as attachment
Off
Enable user to download or export the current view of the table as a CSV file. Download is to the local file system. Export is to 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 will be 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
Column settings
Formatting
Column stylesComma separated list of styles. Each style
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 in sequence. If a column is skipped, supply a comma before adding the next columns styleas provided in the editor window. A style can be reused for subsequent columns 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.
Click Image Added 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 column
Off
Turn this parameter On to show an additional column that show row number for each data row.
Note
If this parameter is On, the first column styles defined in the formatting tab are applied to the row numbers column/numbered list.
autoNumber
Enable sorting on auto number column
Off
Turn 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 rows
On
Any column attributes provided will be applied to the all column rows including heading rows. Turn this parameter Offto have the column attributes apply only to data rows.
enableHeadingAttributes
Auto total numeric columns
Off
Turn 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 sorting
On
Turn 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 order
Off
If sortColumn is used, this determines the order of the sort that is automatically done before display.
sortDescending
Off
Turn this parameter On 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.
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
settings
formatting
Data rows
Row stylesA comma separated list of styles. Each style
Click Start Styling to format your table rows.
Each of the row styles is made up of one or more properties. The first Each style 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. A style can be reused for subsequent rows by referring to it using a 1-based numeric reference. Row 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.
Number 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 rows
0
Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.
footing
Advanced settings
Retain row style order after resorting
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
Enable row highlighting on mouse over
On
As the mouse moves over a table row, the row will be highlighted by default. Turn this parameter Off to stop this behavior.
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.
