2.5.98.8 DVParsedFormula
This structure specifies a formula (section 2.2.2) used in a data validation 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 less than 16385.
rgce (variable): An Rgce (section 2.5.98.88) structure that specifies the sequence of Ptg (section 2.5.98.16) 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), PtgRefErr3d (section 2.5.98.71), PtgNameX (section 2.5.98.61), PtgMemArea (section 2.5.98.54), or PtgMemNoMem (section 2.5.98.57). It 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 the BrtDVal (section 2.4.353) record that contains this DVParsedFormula in its BrtDVal.formula1 field has a BrtDVal.valType not equal to 3, then the following MUST be true:
rgce MUST NOT contain a PtgArea3d (section 2.5.98.19) or a PtgAreaErr3d (section 2.5.98.21).
A PtgArea (section 2.5.98.18), a PtgAreaErr (section 2.5.98.20), or a PtgAreaN (section 2.5.98.22), 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 (section 2.5.98.88).
If the BrtDVal (section 2.4.353) record that contains this DVParsedFormula in its BrtDVal.formula1 field has a BrtDVal.valType equal to 3, then the following MUST be true:
If rgce contains a PtgArea3d or a PtgAreaErr3d (section 2.5.98.21), 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 (section 2.5.98.88).
If this DVParsedFormula is a BrtDVal.formula2 field, the following MUST be true:
rgce MUST NOT contain a PtgArea3d or a PtgAreaErr3d (section 2.5.98.21).
A PtgArea (section 2.5.98.18), a PtgAreaErr (section 2.5.98.20), or a PtgAreaN (section 2.5.98.22) 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 (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.