Export (0) Print
Expand All
Expand Minimize

2.4.150 Lbl

Office

The Lbl record specifies a defined name.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

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

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<96> 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.

Show:
© 2014 Microsoft