2.5.43 ExternalNameProperties
The ExternalNameProperties structure specifies properties of an external defined name (section 2.2.7.4.1.1).
The following packet diagram specifies this structure.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
unused1 |
iSheet |
||||||||||||||||||||||||
|
... |
G |
unused2 |
|||||||||||||||||||||||||||||
A - fBuiltIn (1 bit): A bit that specifies whether the application defines this external defined name. Otherwise, the user defines the external defined name.
B - reserved1 (1 bit): This value MUST be 0 and MUST be ignored.
C - reserved2 (1 bit): This value MUST be 0 and MUST be ignored.
D - reserved3 (1 bit): This value MUST be 0 and MUST be ignored.
E - reserved4 (1 bit): This value MUST be 0 and MUST be ignored.
F - reserved5 (1 bit): This value MUST be 0 and MUST be ignored.
unused1 (10 bits): This value is undefined and MUST be ignored.
iSheet (4 bytes): An unsigned integer that specifies the scope of this external defined name.
-
The value of this field MUST be a value from the following table.
-
Value
Meaning
0
The external defined name has a workbook-level scope.
>0
The external defined name has a sheet-level scope. This value MUST specify a one-based index of an element in the array of XLWideString (section 2.5.169) structures specified by the sheetNames field of the BrtSupTabs (section 2.4.814) record in this External Link (section 2.1.7.25) part ABNF. The referenced string specifies the name of the sheet that is in scope.
G - reserved6 (1 bit): This value MUST be 0 and MUST be ignored.
unused2 (7 bits): This value is undefined and MUST be ignored.