2.5.198.9 DVParsedFormula

Office

The DVParsedFormula structure specifies a formula (section 2.2.2) used in a data validation 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

unused

rgce (variable)

...

cce (2 bytes): An unsigned integer that specifies the length of rgce in bytes.

unused (2 bytes): Undefined and MUST be ignored.

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, PtgRefErr3dPtgNameX, PtgMemArea, or PtgMemNoMem.

If the Dv record that contains this DVParsedFormula in its Dv.formula1 field has a Dv.valType not equal to 3, then the following MUST be true:

  • rgce MUST NOT contain a PtgArea3d or a PtgAreaErr3d.

  • A PtgArea, a PtgAreaErr, or a PtgAreaN, MUST NOT be the only Ptg in rgce.

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

    If the Dv record that contains this DVParsedFormula in its Dv.formula1 field has a Dv.valType equal to 3, then the following MUST be true:

  • If rgce contains a PtgArea3d or a PtgAreaErr3d then the PtgArea3d or PtgAreaErr3d MUST be the only Ptg in rgce.

  • The root node of the parse tree of this field MUST NOT be a VALUE_TYPE, as described in Rgce.

    If this DVParsedFormula is in Dv.formula2 field, then the following MUST be true:

  • rgce MUST NOT contain a PtgArea3d or a PtgAreaErr3d.

  • A PtgArea, a PtgAreaErr, or a PtgAreaN, MUST NOT be the only Ptg in rgce.

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

Show: