2.5.98.19 PtgArea3d

The PtgArea3d operand (section 2.5.98.88) specifies a reference to the same rectangular range of cells on one or more sheets.

If the formula containing this structure is part of a revision as specified in the Formulas overview (section 2.2.2), then there MUST be a RevExtern (section 2.5.98.80) in the RgbExtra (section 2.5.98.87) 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. This value MUST be 0x1B.

A - type (2 bits):  A PtgDataType (section 2.5.98.36) structure that specifies the data type for the value of this Ptg (section 2.5.98.16).

B - reserved (1 bit):  This value MUST be 0, 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 (section 2.2.2), then this value is an XtiIndex (section 2.5.98.103) that specifies the Xti (section 2.5.173) that specifies those sheets. Otherwise, it is undefined and MUST be ignored.

area (12 bytes):  A value that specifies coordinates of the referenced range of a cell. If this PtgArea3d is part of a NameParsedFormula (section 2.5.98.12), then this is a RgceAreaRel (section 2.5.98.90) value. Otherwise, it is a RgceArea (section 2.5.98.89) value.