Number of rows to be considered as heading rows. Heading rows do not participate in column sorting.
footing
1
0
heading
Footing
Number of footer rows
Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.
enableSorting
0
true
footing
Enable column sorting
Set to false to disable sorting.
enableHighlighting
TRUE
true
enableSorting
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.
sortColumn
TRUE
enableHighlighting
Auto Sort descending
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).
sortDescending
false
sortColumn
Automatically sort in descending order
If sortColumn is used, this determines the order of the sort that is automatically done before display.
sortTip
FALSE
sortDescending
Sort tip
on mouse over
text
Text displayed when mouse is over a sortable column. Normally, this value is Click to sort or equivalent translation.
sortIconShow
sortTip
false
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.
highlightColor
FALSE
lightgoldenrodyellow
sortIcon
Highlight color
Color of row when mouse is over a row element. See Web
Use true to show an additional column that show row number for each data row.
autoNumberSortAuto number sort
FALSE
false
autoNumber
Enable sorting on auto number column
Use true to enable the auto number column to be sortable. This will retain the original data row count even after row sorting.
autoTotal
FALSE
false
autoNumberSort
Auto total
row
numeric columns
Use true to append a row to the end of the table that will contain totals of all numeric columns.
columnTypes
columnAttributes
FALSE
Column types
Normally all columns are treated as strings for sorting purposes unless a more specific sort type is provided either by the macro logic (SQL Macro) or by this parameter. The parameter is a comma separated list of column type indicators to identify column types.
S - string
I - integer
F - float (since 5.1.0 may contain comma numeric separator)
FC - float with comma as decimal separator and period as numeric separator (since 5.1.0)
C - currency or similar where it is a float value with pre or post characters
CC - C with comma as decimal separator (since 5.1.0)
X - exclude this column from user selectable sorting
H - hide the column
. or - or : or / - separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by one of the separators indicated by the type.
Enable heading attributes
autoTotal
Enable download and export as attachment
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.
FALSE
allowExport
Column type
Include Page
_ColumnTypes
_ColumnTypes
columnTypes
Total type
Include Page
_ColumnCalculations
_ColumnCalculations
columnCalculations
Header 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. A style can be reused for subsequent rows by referring to it using a 1-based numeric reference. 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.
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.
TRUE
retainRowStyleOrder
Column styles
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 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.
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.
enableHeadingAttributes
true
columnAttributes
Apply column attributes to header rows
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.
id
TRUE
auto generated
enableHeadingAttributes
Table id
Table id can be referenced for use in macros (like the chart macro) or javascript.
class
auto generated
@default
id
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.
style
@default
class
Table style
Style attributes can be set. For example: font-style:italic; background:lightblue;
.
rowStyles
Table row styles
A comma separated listofstyles. Eachstyleismadeupofoneormore properties. Thefirstisappliedtoallheadingrowsdeterminedbytheheadingparameter. Theremainingstylesareappliedtotheremainingrowsinorderwithrepetitionasnecessary
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.
Table width
In pixels or %. Recommend using style settings instead.
border
Table border
width
Border width
In pixels. Set class to blank also. Recommend using style settings instead.