2.5.98.69 PtgRef3d

The PtgRef3d operand (section 2.5.98.88) specifies a reference to a single cell 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 PtgRef3d, 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

loc

...

...

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

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.

loc (6 bytes):  A value that specifies coordinates of the referenced cell. If this PtgRef3d is part of a NameParsedFormula (section 2.5.98.12), then this is a RgceLocRel (section 2.5.98.92) value. Otherwise, it is a RgceLoc (section 2.5.98.91) value.