2.5.98.61 PtgNameX
The PtgNameX structure specifies a reference to a defined name in an external workbook (section 2.1.10).
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 RevName (section 2.5.98.83) in the RgbExtra (section 2.5.98.87) corresponding to this PtgNameX, which specifies the defined name.
If the formula containing this structure is not part of a revision as specified in the Formulas overview (section 2.2.2), then the referenced defined name is specified by an XtiIndex (section 2.5.98.103).
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ptg |
A |
B |
ixti |
nameindex |
|||||||||||||||||||||||||||
... |
ptg (5 bits): Reserved. This value MUST be 0x19.
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), this value is an XtiIndex that specifies the referenced defined name. The XtiIndex MUST specify an Xti (section 2.5.173) that is a reference to a BrtSupBookSrc (section 2.4.800) record.
-
If the formula containing this structure is part of a revision as specified in the Formulas overview (section 2.2.2), this value is undefined and MUST be ignored.
nameindex (4 bytes): If the formula containing this structure is not part of a revision as specified in the Formulas overview (section 2.2.2), this value is an unsigned integer that specifies the one-based index of a BrtSupNameStart (section 2.4.809) record in the collection of BrtSupNameStart records in the External Link (section 2.1.7.25) part ABNF that is specified by the BrtSupBookSrc record referenced by ixti. The referenced and its associated records specify the defined name referenced by this record.
-
If the formula containing this structure is part of a revision as specified in the Formulas overview (section 2.2.2), this value is undefined and MUST be ignored.