Share via

2.5.39 CFVO

  • Article

The CFVO structure specifies a Conditional Formatting Value Object (CFVO) that specifies how to calculate a value from the range of cells that a conditional formatting rule applies to.

The value this structure specifies how to calculate is referred to as a CFVO value in other records.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

cfvoType

fmla (variable)

...

numValue (optional)

...

cfvoType (1 byte): An unsigned integer that specifies how the CFVO value is determined.  In the following table, X represents a parameter value. If fmla.cce is greater than zero, then X is the result of evaluating fmla, otherwise, X is numValue.  cfvoType MUST be one of the following values:

Value

Meaning of CFVO Value

0x01

X

0x02

The minimum value from the range of cells that the conditional formatting rule applies to.

0x03

The maximum value from the range of cells that the conditional formatting rule applies to.

0x04

The minimum value in the range of cells that the conditional formatting rule applies to plus X percent of the difference between the maximum and minimum values in the range of cells that the conditional formatting rule applies to.

For example, if the min and max values in the range are 1 and 10 respectively, and X is 10, then the CFVO value is 1.9.

0x05

The minimum value of the cell that is in X percentile of the range of cells that the conditional formatting rule applies to.

0x07

The result of evaluating fmla.

fmla (variable):  A CFVOParsedFormula that specifies the formula used to calculate the CFVO value. If cfvoType is 0x07, then fmla.cce MUST be greater than zero.

numValue (8 bytes): An Xnum (section 2.5.342) that specifies a static value used to calculate the CFVO value. MUST be omitted if fmla.cce is greater than zero, or if cfvoType is equal to 0x02 or 0x03. MUST be greater than 0.0 and less than 100.0 if cfvoType is either 0x04 or 0x05