2.5.198.28 PtgArea3d

Office

The PtgArea3d operand specifies a reference to the same rectangular range of cells on one or more sheets. If the formula (section 2.2.2) containing this structure is part of a revision as specified in the Formulas overview, then there MUST be a RevExtern in the RgbExtra corresponding to this PtgArea3d, which specifies those sheets.


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

ptg

A

B

ixti

area

...

...

ptg (5 bits): Reserved. MUST be 0x1B.

A - type (2 bits): A PtgDataType that specifies the required data type for the value of the Ptg

B - reserved (1 bit):  MUST be zero, and MUST be ignored.

ixti (2 bytes): If the formula containing this structure is not part of a revision as specified in the Formulas overview, then this value is an XtiIndex that specifies the XTI which specifies those sheets. Otherwise it is undefined and MUST be ignored.

area (8 bytes):  A value that specifies coordinates of the referenced range of  cells. If this PtgArea3d is part of a NameParsedFormula then this is an RgceAreaRel value. Otherwise it is an RgceArea value.

Show: