2.4.352 BrtDRef
The BrtDRef record specifies a data reference used by data consolidation. A data reference is either an UncheckedRfX (section 2.5.154) or a defined name.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
fName |
fBuiltin |
rfx (16 bytes, optional) |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
reserved1 (optional) |
||||||||||||||||||||||||||||||
|
... |
reserved2 (optional) |
||||||||||||||||||||||||||||||
|
... |
reserved3 (optional) |
||||||||||||||||||||||||||||||
|
... |
reserved4 (optional) |
||||||||||||||||||||||||||||||
|
... |
xstrName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
xstrSheet (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
relId (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
fName (1 byte): A Boolean (section 2.5.98.3) that specifies whether this data reference is a cell range or a defined name. This value MUST be a value in the following table.
-
Value
Meaning
0x00
This data reference refers to a cell range.
0x01
This data reference refers to a defined name.
fBuiltin (1 byte): A Boolean (section 2.5.98.3) that specifies whether the value of xstrName refers to a built-in defined name or a user-created defined name. When fName is 0x00, fBuiltin MUST be 0x00. When fName is 0x01, fBuiltin MUST be a value in the following table.
-
Value
Meaning
0x00
The value in xstrSheet refers to a user-created defined name.
0x01
The value in xstrSheet refers to a built-in defined name. The value in xstrSheet MUST be one of values in the following list:
Consolidate_Area
Auto_Open
Auto_Close
Extract
Database
Criteria
Print_Area
Print_Titles
Recorder
Data_Form
Auto_Activate
Auto_Deactivate
Sheet_Title
_FilterDatabase
rfx (16 bytes): An UncheckedRfX that specifies the cell range referenced by this data reference. This value exists if and only if fName is 0x00.
reserved1 (4 bytes): This value MUST be equal to 1,048,576 and MUST be ignored. Exists if and only if fName is 0x01.
reserved2 (4 bytes): This value MUST be equal to 1,048,576 and MUST be ignored. Exists if and only if fName is 0x01.
reserved3 (4 bytes): This value MUST be equal to 16,384 and MUST be ignored. Exists if and only if fName is 0x01.
reserved4 (4 bytes): This value MUST be equal to 16,384 and MUST be ignored. Exists if and only if fName is 0x01.
xstrName (variable): An XLWideString (section 2.5.169) that specifies the name of this data reference. When fName is 0x00, this field MUST be an empty XLWideString. When fName is 0x01, xstrName MUST specify a non-empty string which represents the name of this data reference.
xstrSheet (variable): An XLWideString that specifies the name of the sheet containing the source of this data reference. If fName is 0x01 and the defined name has workbook scope, xstrSheet MUST be an empty XLWideString. Otherwise, xstrSheet MUST be the name of the sheet which contains this data reference.
relId (variable): A RelID (section 2.5.115) that specifies the source of this data reference. When this data reference refers to an external workbook (section 2.1.10), relId MUST specify the relationship identifier describing this external reference. Otherwise, relId MUST be a zero-length RelID.