2.5.58 FRTDVParsedFormula14
The FRTDVParsedFormula14 structure specifies a formula (section 2.2.2) used in a data validation rule.
The following packet diagram specifies this structure.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
frtformula (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
frtformula (variable): An FRTFormula (section 2.5.59) structure that specifies the formula.
-
frtformula.rgce is an Rgce (section 2.5.98.88) structure that specifies the sequence of Ptg (section 2.5.98.16) structures for the formula. It MUST NOT contain a 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), PtgMemArea (section 2.5.98.54), or PtgMemNoMem (section 2.5.98.57) structure. 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 BrtDVal14 (section 2.4.354) record that contains the FRTHeader (section 2.5.61) structure whose FRTHeader.rgFormulas.array contains this FRTDVParsedFormula14 structure has a BrtDVal14.valType attribute not equal to 3, the BrtDVal14.fDVMinFmla attribute is 1 and this FRTDVParsedFormula14 structure is the first formula contained in the FRTHeader.rgFormulas array, the following MUST be true:
A PtgArea (section 2.5.98.18), PtgAreaErr (section 2.5.98.20), PtgAreaN (section 2.5.98.22), PtgArea3d (section 2.5.98.19), or PtgAreaErr3d (section 2.5.98.21) structure MUST NOT be the only Ptg structure in rgce.
The root node of the parse tree of this field MUST be a VALUE_TYPE state, as described in section 2.5.98.88.
If the BrtDVal14 record that contains the FRTHeader structure whose FRTHeader.rgFormulas.array contains this FRTDVParsedFormula14 structure has a BrtDVal14.valType equal to 3, BrtDVal14.fDVMinFmla is 1 and this FRTDVParsedFormula14 structure is the first formula contained in the FRTHeader.rgFormulas array, the following MUST be true:
If rgce contains a PtgArea3d, PtgAreaErr3d, PtgRef3d (section 2.5.98.69), or PtgRefErr3d (section 2.5.98.71) structure, then PtgArea3d, PtgAreaErr3d, PtgRef3d, or PtgRefErr3d MUST be the only Ptg structure in rgce.
The root node of the parse tree of this field MUST NOT be a VALUE_TYPE state, as described in section 2.5.98.88.
If the BrtDVal14 record that contains the FRTHeader structure whose FRTHeader.rgFormulas.array contains this FRTDVParsedFormula14 structure has a BrtDVal14.valType not equal to 3, BrtDVal14.fDVMaxFmla is 1 and this FRTDVParsedFormula14 structure is the last formula contained in the FRTHeader.rgFormulas array, the following MUST be true:
PtgArea, PtgAreaErr, PtgAreaN, PtgArea3d, or PtgAreaErr3d MUST NOT be the only Ptg structure in rgce.
The root node of the parse tree of this field MUST be a VALUE_TYPE state, as described in section 2.5.98.88.