2.4.238 BrtBeginSXCondFmt14
The BrtBeginSXCondFmt14 record specifies the scope, type and priority of conditional formatting applied to this PivotTable view, as specified by the preceding BrtBeginSXView (section 2.4.275) record, and specifies the beginning of a collection of records as defined by the PivotTable (section 2.1.7.40) part ABNF. The collection of records specifies details about where this conditional formatting applies in the PivotTable view. This record is equivalent to BrtBeginSXCondFmt (section 2.4.237) but allows to specify a GUID for the associated BrtBeginCFRule14 (section 2.4.24) record.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
guid (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
sxcondfmtScope |
|||||||||||||||||||||||||||||||
|
reserved |
|||||||||||||||||||||||||||||||
|
ipriority |
|||||||||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the future record information (section 2.1.6) for this record.
guid (16 bytes): A GUID as specified by [MS-DTYP], section 2.3.4, that specifies a particular BrtBeginCFRule14 (section 2.4.24) in the collection of BrtBeginCFRule14 records as defined by the PivotTable (section 2.1.7.40) part ABNF. There MUST exist a BrtBeginCFRule14 with a guid field with the same value as this value, and it MUST be the same BrtBeginCFRule14 specified by ipriority.
sxcondfmtScope (4 bytes): An unsigned integer that specifies the scope of this PivotTable view (section 2.2.5.3) conditional formatting. This value MUST be a value from the following table:
-
Name
Value
Description
SXCONDFMTSELECTIONSCOPE
0x00000000
This conditional formatting is applied to the cells (as specified by the records of the PIVOTRULES14 rule (defined in section 2.1.7.40) of this collection).
SXCONDFMTDATASCOPE
0x00000001
This conditional formatting is applied to all cells (as specified by the records of the PIVOTRULES14 rule of this collection) that display values for the data item (section 2.2.5.3.7.5.1).
SXCONDFMTFIELDSCOPE
0x00000002
This conditional formatting is applied to all cells (as specified by the records of the PIVOTRULES14 rule of this collection) that display values for the pivot field (section 2.2.5.3.2) intersections.
-
reserved (4 bytes): This value MUST be 0 and MUST be ignored.
ipriority (4 bytes): An unsigned integer that specifies the priority of the PivotTable view (section 2.2.5.3) conditional formatting. This value MUST be greater than or equal to 1. The sheet where this PivotTable view is located MUST have a BrtBeginConditionalFormatting14 (section 2.4.35) collection with the fPivot field equal to 1, and there MUST be a BrtBeginCFRule14 (section 2.4.24) item in that collection with the ipri field equal to the value of this field.