2.5.98.98 SharedParsedFormula
The SharedParsedFormula structure specifies the formula (section 2.2.2) for a shared formula.
|
|
|
|
|
|
|
|
|
|
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 greater than 0 and less than 16385.
rgce (variable): An Rgce (section 2.5.98.88) that specifies the sequence of Ptg (section 2.5.98.16) structures for the formula. MUST NOT contain PtgExp (section 2.5.98.40), PtgSxName (section 2.5.98.76), PtgIsect (section 2.5.98.50), PtgUnion (section 2.5.98.78), PtgRange (section 2.5.98.67), PtgArray (section 2.5.98.23), PtgRefErr (section 2.5.98.70), PtgAreaErr (section 2.5.98.20), PtgRef3d (section 2.5.98.69), PtgArea3d, PtgRefErr3d (section 2.5.98.71), PtgAreaErr3d (section 2.5.98.21), 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 PtgRef (section 2.5.98.68), then the loc.column.fColRel and loc.column.fRwRel fields in the PtgRef MUST be 0.
If this field contains a PtgArea (section 2.5.98.18), then the area.columnFirst.fColRel, area.columnFirst.fRwRel, area.columnLast.fColRel, and area.columnLast.fRwRel fields in the PtgArea MUST be 0.
If this field contains a PtgFuncVar (section 2.5.98.46) and the fCeFunc field of the PtgFuncVar is 0, then the tab field of the PtgFuncVar MUST NOT be 0x017B.
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.