2.4.321 TableStyleElement
The TableStyleElement record specifies formatting for one element of a table style. Each table style element specifies the formatting to apply to a particular area of a table or PivotTable view when the table style is applied.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
frtHeader |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
tseType |
|||||||||||||||||||||||||||||||
|
size |
|||||||||||||||||||||||||||||||
|
index |
|||||||||||||||||||||||||||||||
frtHeader (12 bytes): An FrtHeader structure. The frtHeader.rt field MUST be 0x0890.
tseType (4 bytes): An unsigned integer that specifies the area of the table or PivotTable viewto which the formatting is applied. MUST be a value from the following table:
-
Value
Meaning
0x00000000
Whole table. If this table style is applied to a PivotTable view, this formatting type also applies to page field captions and page item captions.
0x00000001
Header row. If this table style is applied to a PivotTable view, this formatting type applies to the collection of rows above the data region. See S in the PivotTable Style Diagram.
0x00000002
Total row. If this table style is applied to a PivotTable view, this formatting type applies to the grand total row. See N in the PivotTable Style Diagram.
0x00000003
First column. If this table style is applied to a PivotTable view, this formatting type applies to the row label area, which can span multiple columns. See R in the PivotTable Style Diagram.
0x00000004
Last column. If this table style is applied to a PivotTable view, this formatting type applies to the grand total column. See A in the PivotTable Style Diagram.
0x00000005
Row stripe band 1
0x00000006
Row stripe band 2
0x00000007
Column stripe band 1
0x00000008
Column stripe band 2
0x00000009
First cell of Header row. If this table style is applied to a PivotTable view, this formatting type applies to cells contained in area intersected by the header row and first column.
0x0000000A
Last cell of header row. MUST be ignored if this table style is applied to a PivotTable view.
0x0000000B
First cell of Total row. MUST be ignored if this table style is applied to a PivotTable view.
0x0000000C
Last cell of Total row. MUST be ignored if this table style is applied to a PivotTable view.
0x0000000D
Outermost subtotal columns in a PivotTable view, specified by the columns displaying subtotals for the first Sxvd record in the PIVOTVD collection where the sxaxis field of the Sxvd record specifies the column axis. See B in the PivotTable Style Diagram. Used only for PivotTables.
0x0000000E
Alternating even subtotal columns in a PivotTable view, specified by the columns displaying subtotals for Sxvd records for which the zero-based index in the PIVOTVD collection is an odd number, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the column axis. See C in the PivotTable Style Diagram. Used only for PivotTables.
0x0000000F
Alternating odd subtotal columns in a PivotTable view, specified by the columns displaying subtotals for Sxvd records for which the zero-based index in the PIVOTVD collection is an even number greater than zero, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the column axis. See D in the PivotTable Style Diagram. Used only for PivotTables.
0x00000010
Outermost subtotal rows in a PivotTable view, specified by the rows displaying subtotals for the first Sxvd record in the PIVOTVD collection where the sxaxis field of the Sxvd record specifies the row axis. See M in the PivotTable Style Diagram. Used only for PivotTables.
0x00000011
Alternating even subtotal rows in a PivotTable view, specified by the rows displaying subtotals for Sxvd records for which the zero-based index in the PIVOTVD collection is an odd number, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the row axis. See K in the PivotTable Style Diagram. Used only for PivotTables.
0x00000012
Alternating odd subtotal rows in a PivotTable view, specified by the rows displaying subtotals for Sxvd records for which the zero-based index in the PIVOTVD collection is an even number greater than zero, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the row axis. See J in the PivotTable Style Diagram. Used only for PivotTables.
0x00000013
Empty rows after each subtotal row. See L in the PivotTable Style Diagram. Used only for PivotTables.
0x00000014
Outermost column subheadings in a PivotTable view, specified by the columns displaying pivot field captions for the first Sxvd record in the PIVOTVD collection where the sxaxis field of the Sxvd record specifies the column axis. See O in the PivotTable Style Diagram. Used only for PivotTables.
0x00000015
Alternating even column subheadings in a PivotTable view, specified by the column columns displaying pivot field captions for Sxvd records for which the zero-based index in the PIVOTVD collection is an odd number, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the column axis. See P in the PivotTable Style Diagram. Used only for PivotTables.
0x00000016
Alternating odd column subheadings in a PivotTable view, specified by the columns displaying pivot field captions for Sxvd records for which the zero-based index in the PIVOTVD collection is an even number greater than zero, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the column axis. See Q in the PivotTable Style Diagram. Used only for PivotTables.
0x00000017
Outermost row subheadings in a PivotTable view, specified by the rows displaying pivot field captions for the first Sxvd record in the PIVOTVD collection where the sxaxis field of the Sxvd record specifies the row axis. See G in the PivotTable Style Diagram. Used only for PivotTables.
0x00000018
Alternating even row subheadings in a PivotTable view, specified by the rows displaying pivot field captions for Sxvd records for which the zero-based index in the PIVOTVD collection is an odd number, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the row axis. See H in the PivotTable Style Diagram. Used only for PivotTables.
0x00000019
Alternating odd row subheadings in a PivotTable view, specified by the rows displaying pivot field captions for Sxvd records for which the zero-based index in the PIVOTVD collection is an even number greater than zero, omitting Sxvd records where the sxaxis field of the Sxvd record does not specify the row axis. See I in the PivotTable Style Diagram. Used only for PivotTables.
0x0000001A
Page field captions in a PivotTable view, specified by the cells displaying pivot field captions for the Sxvd records in the PIVOTVD collection where the sxaxis field of the Sxvd record specifies the page axis. See F in the PivotTable Style Diagram. Used only for PivotTables.
0x0000001B
Page item captions in a PivotTable view, specified by the cells displaying pivot item captions for the Sxvd records in the PIVOTVD collection where the sxaxis field of the Sxvd record specifies the page axis. See E in the PivotTable Style Diagram. Used only for PivotTables.
Figure 18: PivotTable-style diagram
size (4 bytes): An unsigned integer that specifies the number of rows or columns to include in a single stripe band. MUST be ignored when the value of tseType does not equal 0x00000005, 0x00000006, 0x00000007, or 0x00000008. MUST be greater than or equal to 1 and less than or equal to 9.
index (4 bytes): A DXFId structure that specifies the DXF record that contains the differential formatting properties for this element.