Export (0) Print
Expand All

2.2.6.3 Table Styles

Office

Table styles specify additional formatting for cells inside tables or PivotTable views (section 2.2.5.4).

Tables can specify an applied table style with the List12TableStyleClientInforecord (section 2.5.176). PivotTable views (section 2.2.5.4) specify an applied table style with the SXAddl_SXCView_SXDTableStyleClientrecord (section 2.4.273.107). These two records reference a table style by name with the stListStyleName and stName fields, respectively.

Table styles are either built-in or custom. Built-in table styles are specified in [ECMA-376] part 4, 3.8.40. Custom table styles used in a workbook are specified in the collection of records beginning with TableStyles (section 2.4.322).

A table style consists of a collection of table style elements (section 2.2.6.2.2). For custom table styles, these elements are specified by the collection of TableStyleElementrecords (section 2.4.321) following the TableStylerecord (section 2.4.320).

Each table style element (section 2.2.6.2.2) specifies the formatting to be applied to cells in a particular region of the table or PivotTable view (section 2.2.5.4). These regions are specified by the possible values of the tseType field of the TableStyleElementrecord (section 2.4.321).

Show:
© 2015 Microsoft