2.4.150 Lbl
The Lbl record specifies a defined name.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
fGrp |
G |
H |
I |
J |
chKey |
cch |
|||||||||||||||||||
|
cce |
reserved3 |
||||||||||||||||||||||||||||||
|
itab |
reserved4 |
reserved5 |
|||||||||||||||||||||||||||||
|
reserved6 |
reserved7 |
Name (variable) |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
rgce (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
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
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.