2.5.198.7 CFVOParsedFormula
The CFVOParsedFormula 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) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
cce (2 bytes): An unsigned integer that specifies the length of rgce in bytes. MUST be greater than 0.
rgce (variable): An Rgce that specifies the sequence of Ptgs for the formula. MUST NOT contain PtgExp, PtgTbl, PtgElfLel, PtgElfRw, PtgElfCol, PtgElfRwV, PtgElfColV, PtgElfRadical, PtgElfRadicalS, PtgElfColS, PtgElfColSV, PtgElfRadicalLel, PtgSxName, PtgIsect, PtgUnion, PtgArray, PtgRef3d, PtgArea3d, PtgRefErr3d, PtgAreaErr3d, PtgNameX, PtgMemArea, or PtgMemNoMem. A PtgArea or a PtgAreaN MUST NOT be the only Ptg in the sequence.
-
If this field contains a PtgRef, then the loc.column.colRelative and loc.column.rowRelative fields in the PtgRef MUST be 0.
-
If this field contains a PtgRefN, then the loc.column.colRelative and loc.column.rowRelative fields in the PtgRefN MUST be 0.
-
If this field contains a PtgArea, then the area.columnFirst.colRelative, area.columnFirst.rowRelative, area.columnLast.colRelative, and area.columnLast.rowRelative fields in the PtgArea MUST be 0.
-
If this field contains a PtgAreaN, then the area.columnFirst.colRelative, area.columnFirst.rowRelative, area.columnLast.colRelative, and area.columnLast.rowRelative 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.