3.2.1 Defined Name: BrtName
The first record in this example, BrtName (section 2.4.711), defines the properties of the defined name, as specified in the following table.
Size |
Structure |
Value |
---|---|---|
002E |
BrtName - BrtName |
|
1 bit |
DWORD - fHidden |
0x0 |
1 bit |
DWORD - fFunc |
0x0 |
1 bit |
DWORD - fOB |
0x0 |
1 bit |
DWORD - fProc |
0x0 |
1 bit |
DWORD - fCalcExp |
0x0 |
1 bit |
DWORD - fBuiltin |
0x0 |
9 bits |
DWORD - fgrp |
0x000 |
1 bit |
DWORD - fPublished |
0x0 |
1 bit |
DWORD - fWorkbookParam |
0x0 |
1 bit |
DWORD - unused |
0x0 |
14 bits |
DWORD - reserved |
0x0000 |
0001 |
BYTE - chKey |
0x00 |
0004 |
DWORD - itab |
0xFFFFFFFF |
0010 |
XLNameWideString - name |
MyName |
0011 |
NameParsedFormula - formula |
|
0004 |
DWORD - cce |
0x00000009 |
0009 |
Rgce - rgce |
|
0009 |
PtgRef3d - PtgRef3d |
|
0001 |
BYTE - ptg |
0x1A |
0001 |
PtgDataType - type |
0x01 |
0001 |
BYTE - reserved |
0x00 |
0002 |
USHORT - ixti |
0x0000 |
0006 |
RgceLoc - loc |
|
0004 |
UncheckedRw - row |
0x00000003 |
0002 |
ColRelShort - column |
|
14 bits |
USHORT - col |
0x0004 |
1 bit |
DWORD - fColRel |
0x0 |
1 bit |
DWORD - fRwRel |
0x0 |
0004 |
DWORD - cb |
0x00000000 |
0004 |
XLNullableWideString - comment |
|
Structure of BrtName
fHidden: 0x0 specifies that the defined name is not hidden.
fFunc: 0x0 specifies that the defined name does not represent an XLM macro.
fOB: 0x0 specifies that the defined name does not represent a VBA macro.
fProc: 0x0 specifies that the defined name does not represent a macro.
fCalcExp: 0x0 specifies that the formula.rgce field does not contain a call to a function that can return an array.
fBuiltin: 0x0 specifies that the defined name does not represent a built-in name.
fPublished: 0x0 specifies that the defined name was not published.
fWorkbookParam: 0x0 specifies that the defined name is not a workbook parameter.
chKey: 0x00 specifies that there is no shortcut key for the macro represented by the defined name. This is equal to 0 because fProc is 0.
itab: 0xFFFFFFFF specifies that the scope of the defined name is the entire workbook.
name: "MyName" specifies the name of the defined name.
formula: A NameParsedFormula (section 2.5.98.12) that contains the formula (section 2.2.2) that specifies the sheet and cell range of the workbook associated with the name.
formula.cce: 0x00000009 specifies that there are 9 bytes in formula.rgce.
formula.rgce: An Rgce (section 2.5.98.88) that contains the Ptg (section 2.5.98.16) structures that make up the formula.
formula.rgce.PtgRef3d: A Ptg in the formula.
formula.rgce.PtgRef3d.ptg: 0x1A specifies that this Ptg is of type PtgRef3d (section 2.5.98.69).
formula.rgce.PtgRef3d.type: 0x01 specifies that this PtgRef3d specifies a reference to a range of cells.
formula.rgce.PtgRef3d.ixti: 0x0000 specifies that this PtgRef3d refers to the first Xti (section 2.5.173) in the BrtExternSheet (section 2.4.665) record shown in this example.
formula.rgce.PtgRef3d.loc: A RgceLoc (section 2.5.98.91) that specifies the coordinates of the referenced cell.
formula.rgce.PtgRef3d.loc.row: 0x00000003 specifies that the defined name refers to row 4 of the worksheet.
formula.rgce.PtgRef3d.loc.column: Specifies the column (1) and that the row and column (1) references are absolute references.
formula.rgce.PtgRef3d.loc.column.col: 0x0004 specifies that the defined name refers to column (1) E of the worksheet.
formula.rgce.PtgRef3d.loc.column.fColRel: 0x0 specifies that the column (1) is an absolute reference.
formula.rgce.PtgRef3d.loc.column.fRwRel: 0x0 specifies that the row is an absolute reference.
comment: An XLNullableWideString (section 2.5.167) that specifies a NULL string, which means that there is no comment.