Share via

2.2.6.3 Table Styles

  • Article

Table styles specify additional formatting for cells inside tables, PivotTables (section 2.2.5),  for visual components of slicer views (section 2.2.14.2), or for visual components of timeline views (section 2.2.15.2). Table styles used for slicer views are specified in slicer styles (section 2.2.6.3.1). Table styles used for timeline views are specified in timeline styles (section 2.2.6.3.2).

Tables and PivotTables specify an applied table style with the BrtTableStyleClient (section 2.4.834) record. For tables, this record MUST exist in the collection of records beginning with BrtBeginList (section 2.4.100). For PivotTables, this record MUST exist in the collection of records beginning with BrtBeginSXView (section 2.4.275).

A BrtTableStyleClient (section 2.4.834) record references a table style by name with the stStyleName field.

Table styles are either built-in or user-defined. Built-in table styles for tables and PivotTables (section 2.2.5) are specified in [ISO/IEC29500-1:2016] section 18.8. User-defined table styles are specified in the collection of records beginning with BrtBeginTableStyles (section 2.4.281).

A table style consists of a collection of table style elements (section 2.2.6.2.2). For user-defined table styles, these elements are specified by the collection of BrtTableStyleElement (section 2.4.835) records following BrtBeginTableStyle (section 2.4.280).

Each table style element specifies the formatting to be applied to cells in a particular region of the table or PivotTable, or visual components in a particular region of a slicer view or timeline view. These regions or visual components are specified by the possible values of the tseType field of the BrtTableStyleElement, BrtSlicerStyleElement (section 2.4.793) and BrtTimelineStyleElement (section 2.4.838) records.