2.5.98.7 CFVOParsedFormula
This structure specifies a formula (section 2.2.2) without relative references that is used in a conditional formatting rule.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
cce |
|||||||||||||||||||||||||||||||
|
rgce (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
cb |
|||||||||||||||||||||||||||||||
|
rgcb (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
cce (4 bytes): An unsigned integer that specifies the length of rgce in bytes. 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), PtgNameX (section 2.5.98.61), PtgMemArea (section 2.5.98.54), PtgMemNoMem (section 2.5.98.57), PtgRefErr3d (section 2.5.98.71) or PtgAreaErr3d (section 2.5.98.21). A PtgArea (section 2.5.98.18) or a PtgAreaN (section 2.5.98.22) MUST NOT be the only Ptg 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) record that has a fFutureFunction field with value 1 and a name field with value “_xlfn.LAMBDA” (case-insensitive).
If this field contains a PtgRef (section 2.5.98.68), the loc.column.fColRel and loc.column.fRwRel fields in the PtgRef MUST be 0.
If this field contains a PtgRefN (section 2.5.98.72), the loc.column.fColRel and loc.column.fRwRel fields in the PtgRefN MUST be 0.
If this field contains a PtgArea (section 2.5.98.18), the area.columnFirst.fColRel, area.columnFirst.fRwRel, area.columnLast.fColRel, and area.columnLast.fRwRel fields in the PtgArea MUST be 0.
If this field contains a PtgAreaN (section 2.5.98.22), the area.columnFirst.fColRel, area.columnFirst.fRwRel, area.columnLast.fColRel, and area.columnLast.fRwRel fields in the PtgAreaN MUST be 0.
The root node of the parse tree of this field MUST be a VALUE_TYPE, as described in Rgce (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.