2.5.198.77 PtgNameX
The PtgNameX structure specifies a reference to a defined name in an external workbook.
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 RevName in the RgbExtra corresponding to this PtgNameX that 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.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ptg |
A |
B |
ixti |
nameindex |
|||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
ptg (5 bits): Reserved. MUST be 0x19.
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, this value is an XtiIndex that specifies the XTI that specifies the referenced defined name.
-
If the formula containing this structure is part of a revision as specified in the Formulas overview, 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, this value is an unsigned integer that specifies the one-based index of an ExternName record in the collection of ExternName records directly following the SupBook record referenced by ixti. The referenced ExternName and its associated records specify the referenced defined name.
-
If the formula containing this structure is part of a revision as specified in the Formulas overview, this value is undefined and MUST be ignored.