2.4.150 Lbl

The Lbl record specifies a defined name.

A - fHidden (1 bit): A bit that specifies whether the defined name is not visible in the list of defined names.

B - fFunc (1 bit): A bit that specifies whether the defined name represents an Excel macro (XLM). If this bit is 1, fProc MUST also be 1.

C - fOB (1 bit): A bit that specifies whether the defined name represents a Visual Basic for Applications (VBA) macro. If this bit is 1, the fProc MUST also be 1.

D - fProc (1 bit): A bit that specifies whether the defined name represents a macro.

E - fCalcExp (1 bit): A bit that specifies whether rgce contains a call to a function that can return an array.

F - fBuiltin (1 bit): A bit that specifies whether the defined name represents a built-in name.

fGrp (6 bits): An unsigned integer that specifies the function category for the defined name. MUST be less than or equal to 31. The values 17 to 31 are user-defined. User-defined values are specified in the FnGroupName record. The values 0 to 16 are defined as specified in the following table:

Value	Category
0	All
1	Financial
2	Date Time
3	Math Trigonometry
4	Statistical
5	Lookup
6	Database
7	Text
8	Logical
9	Info
10	Commands
11	Customize
12	Macro Control
13	DDE External
14	User Defined
15	Engineering
16	Cube

G - reserved1 (1 bit): MUST be zero, and MUST be ignored.

H - fPublished (1 bit): A bit that specifies whether the defined name is published. This bit is ignored if the fPublishedBookItems field of the BookExt_Conditional12 structure is 0.

I - fWorkbookParam (1 bit): A bit that specifies whether the defined name is a workbook parameter.

J - reserved2 (1 bit): MUST be zero, and MUST be ignored.

chKey (1 byte):  The unsigned integer value of the ASCII character that specifies the shortcut key for the macro represented by the defined name. MUST be 0 (no shortcut key) if fFunc is 1 or if fProc is 0. Otherwise MUST<97> be greater than or equal to 0x41 and less than or equal to 0x5A, or greater than or equal to 0x61 and less than or equal to 0x7A.

cch (1 byte): An unsigned integer that specifies the number of characters in Name. MUST be greater than or equal to zero.

cce (2 bytes): An unsigned integer that specifies length of rgce in bytes.

reserved3 (2 bytes): MUST be zero, and MUST be ignored.

itab (2 bytes): An unsigned integer that specifies if the defined name is a local name, and if so, which sheet it is on. If itab is not 0, the defined name is a local name and the value MUST be a one-based index to the collection of BoundSheet8 records as they appear in the Globals Substream.

reserved4 (1 byte): MUST be zero, and MUST be ignored.

reserved5 (1 byte): MUST be zero, and MUST be ignored.

reserved6 (1 byte): MUST be zero, and MUST be ignored.

reserved7 (1 byte): MUST be zero, and MUST be ignored.

Name (variable): An XLUnicodeStringNoCch structure that specifies the name for the defined name. If fBuiltin is 0, this field MUST satisfy the same restrictions as the name field of the XLNameUnicodeString structure. If fBuiltin is 1, this field is for a built-in name. Each built-in name has a zero-based index value associated with it. A built-in name or its index value MUST be used for this field. The built-in names are defined in the following table:

Values	Names
0x00	Consolidate_Area
0x01	Auto_Open
0x02	Auto_Close
0x03	Extract
0x04	Database
0x05	Criteria
0x06	Print_Area
0x07	Print_Titles
0x08	Recorder
0x09	Data_Form
0x0A	Auto_Activate
0x0B	Auto_Deactivate
0x0C	Sheet_Title
0x0D	_FilterDatabase

rgce (variable): A NameParsedFormula structure that specifies the formula for the defined name.