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.