2.5.198.24 PivotParsedFormula

Office

The PivotParsedFormula structure specifies a formula (section 2.2.2) used in a PivotTable.


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

cSxName

rgce (variable)

...

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

cSxName (2 bytes): An unsigned integer that specifies number of contiguous SxName records that follow the SxFmla record that contains this formula.

rgce (variable): An Rgce that specifies the sequence of Ptgs for the formula. MUST NOT contain PtgExp, PtgTbl, PtgUnion, PtgIsect, PtgRange, PtgArray, PtgAttrSpaceSemi, PtgAttrSemi, PtgElfLel, PtgElfRw, PtgElfCol, PtgElfRwV, PtgElfColV, PtgElfRadical, PtgElfRadicalS, PtgElfColS, PtgElfColSV, PtgElfRadicalLel, PtgRef, PtgRefErr, PtgRefN, PtgArea, PtgAreaErr, PtgAreaN, PtgRef2.5.198.85d, PtgArea2.5.198.28d, PtgRefErr2.5.198.87d, PtgAreaErr2.5.198.30d, PtgName, PtgNameX, PtgMemArea, PtgMemErr, PtgMemNoMem, or PtgMemFunc.

If this field contains a PtgFunc, then the iftab field of the 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, then the fCeFunc field of the PtgFuncVar MUST be 0 and the tab field of the 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 Rgce.

Show: