Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 21

...

Table plus
highlightColor#ffffec
rowStylesbackground:#f0f0f0;color:#222;font-size:14px;border-bottom:black 2px solid;border-top:black 2px solid;,
multiplefalse
stylebackground-color:white;
autoNumbertrue
Macro Editor Label
ParameterDefault
DescriptionNumber of header rows
Macro Browser LabelDescription

heading

1Heading rows

Number of rows to be considered as heading rows. Heading rows do not participate in column sorting.

Number of footer rows

footing

0Footing rows

Number of rows to be considered as footing rows. Footing rows do not participate in column sorting.

enableSorting

trueEnable column sorting

enableSorting

true
Set to false to disable sorting.

enableHighlighting

trueEnable row highlighting on mouse over

enableHighlighting

true
As the mouse moves over a table row, the row will be highlighted by default. Set to false to stop this behavior.

sortColumn

Automatically

Auto sort
this
column
sortColumn
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).
Automatically sort in descending order

sortDescending

falseSort descendingIf sortColumn is used, this determines the order of the sort that is automatically done before display.

sortTip


Sort tip
textsortTip
on mouse overText displayed when mouse is over a sortable column. Normally, this value is Click to sort or equivalent translation.

sortIcon

falseShow sort iconUse 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.
Highlight color

highlightColor

lightgoldenrodyellowHighlight colorColor of row when mouse is over a row element. See Web Colors for instructions on how to specify this.
Insert auto number column

autoNumber

falseAuto number on each rowUse true to show an additional column that show row number for each data row.
Enable sorting on auto number column

autoNumberSort

falseAuto number sortUse true to enable the auto number column to be sortable. This will retain the original data row count even after row sorting.
Auto total numeric columns

autoTotal

falseAuto total rowUse true to append a row to the end of the table that will contain totals of all numeric columns.
Enable
allowExportfalseAllow download and export
as attachmentallowExportfalse
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.

columnTypes


Column
typecolumnTypes
types
Include Page
_ColumnTypes
_ColumnTypes
Total type
columnCalculations
columnCalculations

Column calculations
Include Page
_ColumnCalculations
_ColumnCalculations

rowStyles

Header

Table row styles
rowStyles

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.

Example: , background:lightyellow, background:lightblue

retainRowStyleOrder

trueRetain row style order
after resorting

retainRowStyleOrder

true
 after sorting

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.

columnStyles
Column styles
columnStyles

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.

Example: background:lightyellow, background:lightblue,1,2,1,2

columnAttributes


Column attributes
columnAttributes
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.
Apply column attributes to header rows

enableHeadingAttributes

trueEnable heading attributesAny 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.
Table id

id

auto generatedTable idTable id can be referenced for use in macros (like the chart macro) or javascript.
Table

class

@defaultTable 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.
Table

style


Table styleStyle attributes can be set. For example: font-style:italic; background:lightblue;.
Table

width


Table widthIn pixels or %. Recommend using style settings instead.
Border width

border


Table border widthIn pixels. Set class to blank also. Recommend using style settings instead.