2.4.35 BrtBeginConditionalFormatting14
The BrtBeginConditionalFormatting14 record specifies conditional formatting properties for a range and specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF. The collection of records specifies conditional formatting information for a range. This record is equivalent to BrtBeginConditionalFormatting (section 2.4.34) but allows for more than 8192 ranges to which this conditional formatting is applied.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
ccf |
|||||||||||||||||||||||||||||||
|
fPivot |
|||||||||||||||||||||||||||||||
FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the Future Record (section 2.1.6) information for this record.
The FRTHeader fields MUST have the values listed in the following table.
-
Field
Value
FRTHeader.fRef
0
FRTHeader.fSqref
1
FRTHeader.fFormulas
0
FRTHeader.fRelID
0
-
The FRTHeader.rgSqrefs specifies the range this conditional formatting applies to. The FRTHeader.rgSqrefs.csqref field MUST equal 1. The sqrfx.crfx field of the single FRTSqref (section 2.5.66) comprising the array of the FRTHeader.rgSqrefs field MUST be greater than or equal to 1.
ccf (4 bytes): An unsigned integer that specifies the count of BrtBeginCFRule14 (section 2.4.24) records contained in this collection.
fPivot (4 bytes): A Boolean (section 2.5.98.3) that specifies whether this conditional formatting is applied only to a PivotTable (section 2.1.7.40). This value MUST be a value from the following table.
-
Value
Meaning
0x00000000
The range specified within FRTHeader.rgSqrefs includes some cells that are not part of a PivotTable data area (section 2.2.5.3.8.1.4).
0x00000001
The range specified within FRTHeader.rgSqrefs only includes cells that are part of a PivotTable data area (section 2.2.5.3.8.1.4).
-