2.4.331 BrtCFVO
The BrtCFVO 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.
The value this structure specifies how to calculate is referred to as a CFVO value in other records.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
iType |
|||||||||||||||||||||||||||||||
|
numParam |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
fSaveGTE |
|||||||||||||||||||||||||||||||
|
fGTE |
|||||||||||||||||||||||||||||||
|
cbFmla |
|||||||||||||||||||||||||||||||
|
formula (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
iType (4 bytes): A CFVOtype (section 2.5.19) that specifies how the CFVO value is determined.
If this record is preceded by a BrtBeginColorScale (section 2.4.28) record and specifies the beginning of the color scale, then this value MUST NOT be CFVOMAX.
If this record is preceded by a BrtBeginColorScale record and specifies the end of the color scale, then this value MUST NOT be CFVOMIN.
If this record is preceded by a BrtBeginColorScale record and specifies the midpoint of the color scale, then this value MUST NOT be CFVOMAX and MUST NOT be CFVOMIN.
If this record is preceded by a BrtBeginDatabar (section 2.4.43) record and specifies the cell value for the shortest data bar, then this value MUST NOT be CFVOMAX.
If this record is preceded by a BrtBeginDatabar record and specifies the cell value for the longest data bar, then this value MUST NOT be CFVOMIN.
If this record is preceded by a BrtBeginIconSet (section 2.4.91) record, then this value MUST NOT be CFVOMAX or CFVOMIN.
If iType is CFVOMIN or CFVOMAX, numParam, cbFmla, and formula are all undefined and MUST be ignored.
If iType is CFVOFMLA, numParam is undefined and MUST be ignored.
If iType is CFVONUM, CFVOPERCENT, or CFVOPERCENTILE and cbFmla is greater than 0, then numParam is undefined and MUST be ignored.
If iType is CFVONUM, CFVOPERCENT, or CFVOPERCENTILE and cbFmla is 0, then numParam is used.
numParam (8 bytes): An Xnum (section 2.5.172) that specifies the numerical value of this BrtCFVO (section 2.4.331) as specified by iType. If iType is CFVOPERCENT or CFVOPERCENTILE, 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 BrtCFVO. If the current group of BrtCFVO records are not preceded by a BrtBeginIconSet 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 BrtCFVO 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 BrtCFVO records is not preceded by a BrtBeginIconSet record and therefore does not describe an icon set.
cbFmla (4 bytes): An unsigned integer that specifies the length in bytes of formula.rgce.
formula (variable): A CFVOParsedFormula (section 2.5.98.7) that specifies the formula (section 2.2.2) that is evaluated and compared to the cell value by using the comparison method specified by this BrtCFVO.