2.5.98.15 PivotParsedFormula
The PivotParsedFormula structure specifies a formula (section 2.2.2) used in a PivotTable (section 2.1.7.40).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
cce |
|||||||||||||||||||||||||||||||
|
rgce (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
cb |
|||||||||||||||||||||||||||||||
|
rgcb (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
cce (4 bytes): An unsigned integer that specifies the length of rgce in bytes. Its value 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) structures for the formula. MUST NOT contain PtgExp (section 2.5.98.40), PtgUnion (section 2.5.98.78), PtgIsect (section 2.5.98.50), PtgRange (section 2.5.98.67), PtgList (section 2.5.98.52), PtgArray (section 2.5.98.23), PtgAttrSpaceSemi (section 2.5.98.31), PtgAttrSemi (section 2.5.98.29), PtgRef (section 2.5.98.68), PtgRefErr (section 2.5.98.70), PtgRefN (section 2.5.98.72), PtgArea (section 2.5.98.18), PtgAreaErr (section 2.5.98.20), PtgAreaN (section 2.5.98.22), PtgRef3d (section 2.5.98.69), PtgArea3d (section 2.5.98.19), PtgRefErr3d (section 2.5.98.71), PtgAreaErr3d (section 2.5.98.21), PtgName (section 2.5.98.60), PtgNameX (section 2.5.98.61), PtgMemArea (section 2.5.98.54), PtgMemErr (section 2.5.98.55), PtgMemNoMem (section 2.5.98.57), or PtgMemFunc (section 2.5.98.56). 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 this field contains a PtgFunc (section 2.5.98.45), then the iftab field of PtgFunc MUST be less than 0x0028 or greater than 0x002D and MUST NOT be equal to 0x002F, 0x00BD, 0x00C3, 0x00C4, or 0x00C7.
If this field contains a PtgFuncVar (section 2.5.98.46), then the value of the fCeFunc field of PtgFuncVar MUST be 0 and the tab field of PtgFuncVar MUST NOT be equal to 0x00FF or 0x0166.
The root node of the parse tree of this field MUST be a VALUE_TYPE, as described in 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.