2.4.237 BrtBeginSXCondFmt
The BrtBeginSXCondFmt record specifies the scope, type and priority of conditional formatting applied to this PivotTable view (section 2.2.5.3), 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.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
sxcondfmtScope |
|||||||||||||||||||||||||||||||
|
sxcondfmtType |
|||||||||||||||||||||||||||||||
|
ipriority |
|||||||||||||||||||||||||||||||
sxcondfmtScope (4 bytes): An unsigned integer that specifies the scope of this PivotTable view 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 PIVOTRULES (section 2.1.7.40) of this collection).
SXCONDFMTDATASCOPE
0x00000001
This conditional formatting is applied to all cells (as specified by the PIVOTRULES 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 PIVOTRULES of this collection) that display values for the pivot field (section 2.2.5.3.2) intersections.
-
The value of sxcondfmtScope MUST be SXCONDFMTFIELDSCOPE if sxcondfmtType value is SXCONDFMTTOP10R or SXCONDFMTTOP10C.
-
If the value of this field is SXCONDFMTDATASCOPE or SXCONDFMTFIELDSCOPE there MUST be only one PIVOTRULE within PIVOTRULES of this SXCONDFMT (section 2.1.7.40) as specified in the PivotTable (section 2.1.7.40) part ABNF.
sxcondfmtType (4 bytes): An unsigned integer that specifies the type of this PivotTable view conditional formatting. This value MUST be a value from the following table:
-
Name
Value
Description
SXCONDFMTTOP10NIL
0x00000000
Top N or Bottom N conditional formatting is not evaluated.
SXCONDFMTTOP10A
0x00000001
Top N or Bottom N conditional formatting is evaluated across the entire scope range.
SXCONDFMTTOP10R
0x00000002
Top N or Bottom N conditional formatting is evaluated for each row.
SXCONDFMTTOP10C
0x00000003
Top N or Bottom N conditional formatting is evaluated for each column (1).
-
The value of this field MUST be SXCONDFMTTOP10NIL or SXCONDFMTTOP10A if sxcondfmtScope value is SXCONDFMTSELECTIONSCOPE or SXCONDFMTDATASCOPE.
ipriority (4 bytes): An unsigned integer that specifies the priority of the PivotTable view conditional formatting. This value MUST be greater than or equal to 1. The sheet where this PivotTable view is located MUST have a BrtBeginConditionalFormatting (section 2.4.34) collection with the fPivot field equal to 1, and there MUST be a BrtBeginCFRule (section 2.4.23) item in that collection with the ipri field equal to the value of this field.