Common Table Parameters - 11.x
On this page
Description
Table settings:
Formatting: Allows you to define the styles specific to the table like ID, class, width, and so on.
Advanced settings: Allows you to define the download and export options, and specify the delimiter to be used for the downloaded or exported file. Show a panel to filter table data with regular expressions. See Regular expressions.
Column settings:
Formatting: Allows you to define column styles such as fonts, colors, column width, column type, and other display attributes using CSS styles. In this panel, enter the number of columns you want to add, and click Start formatting to view the style parameters for all the columns in sequential order. Click Add formatting to add column(s) to the list.
To define column attributes, click and select the Show column attributes option. The Show empty columns option, when selected, displays the columns for which the styling undefined.Numbering & totaling: Allows you to define the numbering attributes like auto numbering the table, totaling the numeric columns, and so on. Specify if you want to make custom defined column styles to override the default Confluence styles. Overriding default Confluence styles are supported from 10.2.0 version.
Sorting: Allows you to define the sorting attributes like sorting the columns in ascending or descending order, displaying sort icon, and so on.
Row formatting:
Data rows: Allows you to define row styles such as fonts, colors, and other display attributes using CSS styles. In this panel, enter the number of rows you want to add, and click Start formatting to view the style parameters for all the rows in sequential order. Click Add formatting to add row(s) to the list.
Header rows: Allows you to define header and footer row styles.
Advanced settings: Allows you to define advanced settings such as row highlight color and so on. Specify if you want to make custom defined row styles to override the default Confluence styles. Overriding default Confluence styles are supported from 10.2.0 version.
Common table parameters
The parameters listed on this page are part of our common table capabilities that are available to many macros that produce or modify tables.
Tabs | Macro Editor Label | Default | Description | Macro Parameter |
|---|---|---|---|---|
Table settings | ||||
Formatting | Table id | auto generated | Generates table ID that can be referenced for use in macros (like the chart macro) or Javascript. | id |
Table class | @default | Enter the class of styles to be applied for the table. By default, value is confluenceTable. Use a blank (one or more spaces) value to not have any table class. | class | |
Table style |
| Enter style attributes for the table. For example: | style | |
Table width |
| Enter width for the table in pixels or %. Recommend use of Table style instead. | width | |
Border width |
| Enter width for the table border in pixels. Set class to blank. Recommend use of Table style instead. | border | |
Advanced settings | Enable download and export as attachment | Off | Enable this option to allow download or export of the current view of the table as a CSV file. Downloads to the local file system. Exports table 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 displayed to the right of the table. Available since SQL 8.3.0. | allowExport |
File delimiter to use when download and export is enabled. Default value is comma. | , (Comma) | 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:
Valid only if Enable download and export as attachment is enabled. Available since 10.2.0. |
| |
Display data filter | Off | Enable this option 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 10.3.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 semi-colon separated CSS properties. 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, 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 can be overridden by table, row, element styles, or classes. Example: When the Insert auto number column parameter is On, if 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 |
| columnTypes | ||
Total type |
| columnCalculations | ||
Column attributes |
| Click and select Show column attributes to view the respective column attributes field in the editor. Specify a comma-separated list of values to modify cell attributes for the respective column. Each value is a double semi-colon list of attributeName=value pairs that are applied to the column cells. | columnAttributes | |
Numbering & Totaling | Numbering | |||
Insert auto number column | Off | Toggle this option On to show an additional column that shows row number for each data row. | autoNumber | |
Auto number column styles |
| Enter styles to be applied on the auto number column using Cascading Style Sheets (CSS) when auto number is enabled. Example: |
| |
Enable sorting on auto number column | Off | Toggle this option On to enable the auto number column to be sortable. This retains the original data row count even after row sorting. | autoNumberSort | |
Apply column attributes to header rows | On | Toggle this option Off to have the column attributes apply only to data rows. Any column attributes provided is applied to the all column rows including heading rows. | enableHeadingAttributes | |
Apply Column styles to column cells | Off | Toggle this option On to override default Confluence styles and make the styles specified in the Column styles field (Formatting tab) persist for the respective columns. Available since 10.2.0. |
| |
Totaling | ||||
Auto total numeric columns | Off | Toggle this option On to append a row to the end of the table that contains the totals of all numeric columns. | autoTotal | |
Sorting | Enable column sorting | On | Toggle this option Off to disable sorting. | enableSorting |
Automatically sort by this column |
| Enter the column name or column number that the table must be auto sorted on before it is displayed. No auto sorting is performed 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 | Toggle this option On to sort the column(s), specified in Automatically sort by this column, in descending order automatically before the table is displayed. | sortDescending | |
Display sort icon | Off | Toggle this option On to include a sort icon in the first heading row for sortable columns. An icon is shown for the last column sorted indicating the direction the column was sorted. | sortIcon | |
Sort tip text |
| Enter the text to be displayed when mouse is over a sortable column. For example, this value can be Click to sort or an equivalent translation. | sortTip | |
Row formatting | ||||
Data rows | Row styles |
| Click Start Styling to format your table rows. Each row style is made up of one or more properties that is applied to the respective row. Row styles are applied to the specified table row and participate with other CSS properties to determine the look of an element. In particular, some properties can be overridden by table, element styles, or classes. Example:
| row index |
Header & Footer rows | Number of header rows | 1 | Enter the number of rows to be considered as heading rows. Heading rows do not participate in column sorting. | heading |
Header row styles |
| Enter a comma separated list of styles, similar to Row styles (Data rows tab), to be applied on the header row. | rowStyles | |
Advanced settings | Retain row style order after re-sorting | On | Toggle this option Off to retain the original style given to a row regardless where the row lands after sorting. By default, the row styles correspond to the order the rows are displayed on the screen. When disabled, the original style given to a row is retained not matter where the row lands after sorting. | retainRowStyleOrder |
Apply Row styles to row cells | Off | Toggle this option On to override default Confluence styles and make the styles specified in the Row styles field (Data rows tab) persist for the respective rows. Available since 10.2.0. |
| |
Enable row highlighting on mouse over | On | Toggle this option Off to stop highlighting the table row as the mouse moves over it. | enableHighlighting | |
Highlight color | lightgoldenrodyellow | Enter a color of row when mouse is over a row element. See Web Colors for instructions on how to specify this. | highlightColor | |
Need support? Create a request with our support team.