2.5.98.21 PtgAreaErr3d

The PtgAreaErr3d operand (section 2.5.98.88) specifies an invalid reference to the same rectangular range of cells on multiple 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 PtgAreaErr3d, 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

unused1

...

unused2

...

unused3

...

ptg (5 bits):  Reserved. This value MUST be 0x1D.

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.

unused1 (4 bytes):  Undefined. This value MUST be ignored.

unused2 (4 bytes):  Undefined. This value MUST be ignored.

unused3 (4 bytes):  Undefined. This value MUST be ignored.