2.4.321 TableStyleElement

Office

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.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

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.

PivotTable-style diagram

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.

Show: