2.5.150 TSEType
TSEType is an unsigned integer that specifies the area of the table, PivotTable (section 2.1.7.40), slicer (section 2.2.14) or timeline (section 2.2.15) to which a table style element (section 2.2.6.2.2) applies.
Figure 18: PivotTable Style Diagram
MUST be a value from the following table:
|
Name |
Value |
Meaning |
|---|---|---|
|
0x00000000 |
Whole table, slicer or timeline. If this table style (section 2.2.6.3) is applied to a PivotTable, 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, this formatting type applies to the collection of rows above the data region. See S in the preceding PivotTable Style Diagram. |
|
|
0x00000002 |
Total row. If this table style is applied to a PivotTable, this formatting type applies to the grand total row. See N in the preceding PivotTable Style Diagram. Does not apply to slicers (section 2.2.14). |
|
|
0x00000003 |
First column (1). If this table style is applied to a PivotTable, this formatting type applies to the row label area, which can span multiple columns (1). See R in the preceding PivotTable Style Diagram. Does not apply to slicers. |
|
|
0x00000004 |
Last column (1). If this table style is applied to a PivotTable, this formatting type applies to the grand total column (1). See A in the preceding PivotTable Style Diagram. Does not apply to slicers. |
|
|
0x00000005 |
Row stripe band 1. Does not apply to slicers. |
|
|
0x00000006 |
Row stripe band 2. Does not apply to slicers. |
|
|
0x00000007 |
Column (1) stripe band 1. Does not apply to slicers. |
|
|
0x00000008 |
Column (1) stripe band 2. Does not apply to slicers. |
|
|
0x00000009 |
First cell of header row. If this table style is applied to a PivotTable, this formatting type applies to cells contained in the area intersected by the header row and first column (1). Does not apply to slicers. |
|
|
0x0000000A |
Last cell of header row. MUST be ignored if this table style is applied to a PivotTable. Does not apply to slicers. |
|
|
0x0000000B |
First cell of total row. MUST be ignored if this table style is applied to a PivotTable. Does not apply to slicers. |
|
|
0x0000000C |
Last cell of total row. MUST be ignored if this table style is applied to a PivotTable. Does not apply to slicers. |
|
|
0x0000000D |
Outermost subtotal columns (1) in a PivotTable, specified by the columns (1) displaying subtotals for the first SXVD (section 2.5.84) record in the ISXVDCOLS collection (see section 2.1.7.40). See B in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x0000000E |
Alternating even subtotal columns (1) in a PivotTable, specified by the columns (1) displaying subtotals for SXVD records for which the zero-based index in the record in the ISXVDCOLS collection is an odd number. See C in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x0000000F |
Alternating odd subtotal columns (1) in a PivotTable, specified by the columns (1) displaying subtotals for SXVD records for which the zero-based index in the record in the ISXVDCOLS collection is an even number greater than 0. See D in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000010 |
Outermost subtotal rows in a PivotTable, specified by the rows displaying subtotals for the first SXVD record in the ISXTHRWS collection (see section 2.1.7.40). See M in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000011 |
Alternating even subtotal rows in a PivotTable, specified by the rows displaying subtotals for SXVD records for which the zero-based index in the SXVD record in the ISXTHRWS collection is an odd number. See K in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000012 |
Alternating odd subtotal rows in a PivotTable, specified by the rows displaying subtotals for SXVD records for which the zero-based index in the SXVD record in the ISXTHRWS collection is an even number greater than 0. See J in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000013 |
Empty rows after each subtotal row. See L in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000014 |
Outermost column (1) subheadings in a PivotTable, specified by the columns (1) displaying pivot field (section 2.2.5.3.2) captions for the first SXVD record in the ISXVDCOLS collection. See O in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000015 |
Alternating even column (1) subheadings in a PivotTable, specified by the columns (1) displaying pivot field captions for SXVD records for which the zero-based index in the ISXVDCOLS collection is an odd number. See P in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000016 |
Alternating odd column (1) subheadings in a PivotTable, specified by the columns (1) displaying pivot field captions for SXVD records for which the zero-based index in the ISXVDCOLS collection is an even number greater than 0. See Q in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000017 |
Outermost row subheadings in a PivotTable, specified by the rows displaying pivot field captions for the first SXVD record in the ISXTHRWS collection. See G in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000018 |
Alternating even row subheadings in a PivotTable, specified by the rows displaying pivot field captions for SXVD records for which the zero-based index in the ISXTHRWS collection is an odd number. See H in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x00000019 |
Alternating odd row subheadings in a PivotTable, specified by the rows displaying pivot field captions for SXVD records for which the zero-based index in the ISXTHRWS collection is an even number greater than 0. See I in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x0000001A |
Page field captions in a PivotTable, specified by the cells displaying pivot field captions for the SXVD records in the SXPIS rule (defined in section 2.1.7.40).. See F in the PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x0000001B |
Page item captions in a PivotTable, specified by the cells displaying pivot item (section 2.2.5.3.3) captions for the SXVD records in the SXPIS. See E in the preceding PivotTable Style Diagram. Used for PivotTables only. |
|
|
0x0000001C |
A slicer item with data that is not selected. Used for slicers only. |
|
|
0x0000001D |
A slicer item with no data that is not selected. Used for slicers only. |
|
|
0x0000001E |
A selected slicer item with data. Used for slicers only. |
|
|
0x0000001F |
A selected slicer item with no data. Used for slicers only. |
|
|
0x00000020 |
A slicer item with data that is not selected and over which the mouse is hovering. Used for slicers only. |
|
|
0x00000021 |
A selected slicer item with data and over which the mouse is hovering. Used for slicers only. |
|
|
0x00000022 |
A slicer item with no data that is not selected and over which the mouse is hovering. Used for slicers only. |
|
|
0x00000023 |
A selected slicer item with no data and over which the mouse is hovering. Used for slicers only. |
|
|
0x00000024 |
Timeline style element that applies to the selection label which is the label that indicates the period that has been selected on the timeline. Used for timelines only. |
|
|
0x00000025 |
Timeline style element that applies to the time level which is the level that indicates the time granularity of the timeline. Used for timelines only. |
|
|
0x00000026 |
Timeline style element that applies to the upper row of the time block labels. Used for timelines only. |
|
|
0x00000027 |
Timeline style element that applies to the lower row of the time block labels. Used for timelines only.
|
|
|
0x00000028 |
Timeline style element that applies to the selected time blocks which are the segments on the timeline that have been selected by the user. Used for timelines only. |
|
|
0x00000029 |
Timeline style element that applies to the unselected time blocks which are the segments on the timeline that have not been selected by the user. Used for timelines only.
|
|
|
0x0000002A |
Timeline style element that applies to the area between any two selected time blocks. Used for timelines only. |