NAME: Defined Name (18h) [PXL 2.0]
The NAME record describes a defined name in the workbook.
Record Data
Offset
|
Name
|
Size
|
Contents
|
0 |
grbit |
2 |
Option flags |
2 |
cch |
1 |
Length of the name text, in characters |
3 |
cce |
2 |
Length of the name definition, in bytes |
5 |
ixals |
2 |
Index to sheet that contains name |
7 |
rgch |
Variable |
Name text |
Variable |
rgce |
Variable |
Name definition |
Parameters
- grbit
- grbit fields are as follows:
Bit
|
Size
|
Name
|
Contents
|
0 |
1 |
fHidden |
Set if name is hidden |
1 |
15 |
Unused |
Unused. Must be zero |
cch
The cch field contains the length of the name text.
- rgch
- The rgch field contains the text itself.
- cce
- The cce field contains the length of the name definition.
- rgce
- The rgce field contains the definition itself. The location of the rgce within the record depends on the length of the name text (rgch) field. The name definition (rgce) is stored in the Microsoft Pocket Excel parsed format.
- ixals
- The NAME record stores two types of names: global names and local names. A global name is defined for an entire workbook, and a local name is defined on a single sheet. For example, MyName is a global name, while Sheet1!MyName is a local name. The ixals field in the NAME record will be nonzero for local names.