2.5.98.6 CFParsedFormula

The CFParsedFormula structure specifies a formula (section 2.2.2) used in a conditional formatting rule.


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

cce

rgce (variable)

...

cb

rgcb (variable)

...

cce (4 bytes): An unsigned integer that specifies the length of rgce in bytes. This value MUST be greater than 0 and less than 16385.

rgce (variable):  An Rgce (section 2.5.98.88) structure that specifies the sequence of Ptg (section 2.5.98.16) structures for the formula. MUST NOT contain PtgExp (section 2.5.98.40), PtgList (section 2.5.98.52), PtgSxName (section 2.5.98.76), PtgIsect (section 2.5.98.50), PtgUnion (section 2.5.98.78), PtgArray (section 2.5.98.23), PtgRef3d (section 2.5.98.69), PtgArea3d (section 2.5.98.19), PtgRefErr3d (section 2.5.98.71), PtgAreaErr3d (section 2.5.98.21), PtgNameX (section 2.5.98.61), PtgMemArea (section 2.5.98.54), or PtgMemNoMem (section 2.5.98.57). A PtgArea (section 2.5.98.18) or a PtgAreaN (section 2.5.98.22) MUST NOT be the only Ptg structure in the sequence. The Rgce (section 2.5.98.88) MUST NOT contain a PtgName (section 2.5.98.60) with a nameindex field that specifies a BrtName (section 2.4.711) that has a fFutureFunction field with value 1 and a name field with value “_xlfn.LAMBDA” (case-insensitive).

The root node of the parse tree of this field MUST be a VALUE_TYPE, as described in section 2.5.98.88.

cb (4 bytes): An unsigned integer that specifies the length of rgcb in bytes.

rgcb (variable):  An RgbExtra (section 2.5.98.87) structure that specifies ancillary data for the formula.