2.4.332 BrtCFVO14
The BrtCFVO14 record specifies a Conditional Formatting Value Object (CFVO) that specifies how to calculate a value from the range of cells to which a conditional formatting rule applies. This record is equivalent to BrtCFVO (section 2.4.331) but allows to specify additional values for the iType field.
The value this structure specifies how to calculate is referred to as a CFVO value in other records.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
iType |
|||||||||||||||||||||||||||||||
|
numParam |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
fSaveGTE |
|||||||||||||||||||||||||||||||
|
fGTE |
|||||||||||||||||||||||||||||||
|
cbFmla |
|||||||||||||||||||||||||||||||
FRTHeader (variable): An FRTHeader (section 2.5.61) that specifies the future record (section 2.1.6) information for this record. The FRTHeader flags MUST have the values listed in the following table.
|
Field |
Value |
|---|---|
|
FRTHeader.fRef |
0 |
|
FRTHeader.fSqref |
0 |
|
FRTHeader.fFormula |
0 or 1 |
|
FRTHeader.fRelID |
0 |
The FRTHeader.fFormula MUST be 1 if cbFmla is greater than 0.
If FRTHeader.fFormula is 1, rgFormulas.cformula MUST equal 1. The formula of the single FRTFormula (section 2.5.59) comprising the array of the rgFormulas specifies the FRTCFVOParsedFormula14 (section 2.5.57) for this BrtCFVO14 (section 2.4.332).
iType (4 bytes): A CFVOType14 (section 2.5.20) that specifies how the CFVO value is determined.
§ If this record is preceded by a BrtBeginColorScale14 (section 2.4.29) record and specifies the beginning of the color scale, then this value MUST NOT be CFVOMAX_14.
§ If this record is preceded by a BrtBeginColorScale14 record and specifies the end of the color scale, then this value MUST NOT be CFVOMIN_14.
§ If this record is preceded by a BrtBeginColorScale14 record and specifies the midpoint of the color scale, then this value MUST NOT be CFVOMAX_14 and MUST NOT be CFVOMIN_14.
§ If this record is not preceded by a BrtBeginDatabar14 record, then this value MUST NOT be CFVOAUTOMAX_14 and MUST NOT be CFVOAUTOMIN_14.
§ If this record is preceded by a BrtBeginDatabar14 record and specifies the minimum cell value used for the data bars in this conditional formatting range, then this value MUST NOT be CFVOMAX_14 or CFVOAUTOMAX_14.
§ If this record is preceded by a BrtBeginDatabar14 record and specifies the maximum cell value used for the data bars in this conditional formatting range, then this value MUST NOT be CFVOMIN_14 or CFVOAUTOMIN_14.
§ If this record is preceded by a BrtBeginIconSet14 (section 2.4.92) record, then this value MUST NOT be CFVOMAX_14 or CFVOMIN_14.
§ If iType is CFVOMIN_14, CFVOMAX_14, CFVOAUTOMAX_14, or CFVOAUTOMIN_14, numParam, cbFmla, and formula are all undefined and MUST be ignored.
§ If iType is CFVOFMLA_14, numParam is undefined and MUST be ignored.
§ If iType is CFVONUM_14, CFVOPERCENT_14, or CFVOPERCENTILE_14 and cbFmla is greater than 0, then numParam is undefined and MUST be ignored.
§ If iType is CFVONUM_14, CFVOPERCENT_14, or CFVOPERCENTILE_14 and cbFmla is 0, then numParam is used.
numParam (8 bytes): An Xnum (section 2.5.172) that specifies the numerical value of this BrtCFVO14 as specified by iType. If iType is CFVOPERCENT_14 or CFVOPERCENTILE_14, numParam MUST be greater than or equal to 0 and less than or equal to 100.
fSaveGTE (4 bytes): A Boolean (section 2.5.98.3) that specifies whether the value of fGTE is used to specify the conditional formatting behavior of this BrtCFVO14. If the current group of BrtCFVO14 records are not preceded by a BrtBeginIconSet14 record and therefore not describing an icon set, then this value MUST be ignored. Otherwise, it MUST have a value of 0x00000001.
fGTE (4 bytes): A Boolean that specifies whether the first BrtCFVO14 will use greater-than or greater-than-or-equal-to when applying conditional formatting rules. This value MUST have a value from the following table.
-
Value
Meaning
0x00000000
Greater-than is used when applying conditional formatting rules.
0x00000001
Greater-than-or-equal-to is used when applying conditional formatting rules.
This value MUST be ignored if the current group of BrtCFVO14 records is not preceded by a BrtBeginIconSet14 record and therefore does not describe an icon set.
cbFmla (4 bytes): An unsigned integer that specifies whether a formula (section 2.2.2) is present in FRTHeader. This value MUST be 0x00000000 if there is no formula, and MUST be nonzero if there is. This value MUST be equal to the number of bytes in the formula rgce if a formula is present in FRTHeader.