2.4.167 BrtBeginPCDSRange
The BrtBeginPCDSRange record specifies the properties of the source data (section 2.2.5.2.1) for a PivotCache (section 2.2.5.2) contained in the workbook and specifies beginning of an empty collection of records as defined by the PivotCache Definition (section 2.1.7.38) part ABNF. The collection of records specifies source data for a PivotCache contained in the workbook. The workbook that contains the source data can be this workbook, or an external workbook (section 2.1.10). The location of the source data within the workbook is specified as a defined name, or as a range.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
reserved1 |
B |
reserved2 |
C |
D |
reserved3 |
sheetName (variable) |
||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
relId (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
namedRange (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
range (16 bytes, optional) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fName (1 bit): A bit that specifies that the source data is specified by a defined name. If this value is 1, the location of this data source inside a workbook is specified by namedRange; otherwise, it is specified by range.
reserved1 (7 bits): This value MUST be 0 and MUST be ignored.
B - fBuiltIn (1 bit): A bit that specifies that the defined name specified by namedRange is a built-in name. If the value of fName is 0, this value MUST be 0.
reserved2 (7 bits): This value MUST be 0 and MUST be ignored.
C - fLoadRelId (1 bit): A bit that specifies that the source data is in an external workbook. If this value is 1, the path to the external workbook is specified by RelID (section 2.5.115).
D - fLoadSheet (1 bit): A bit that specifies that the source data is scoped to a single sheet. If fName is 0 then the value of this bit SHOULD be 1.<18>
reserved3 (6 bits): This value MUST be 0 and MUST be ignored.
sheetName (variable): An XLWideString (section 2.5.169) that specifies the name of the sheet to which the source data is scoped. This field exists if and only if the value of fLoadSheet is 1. This string MUST comply with the restrictions specified for the strName field in BrtBundleSh (section 2.4.313).
relId (variable): A RelID that specifies a relationship that specifies a path to an external workbook that contains the source data. This field exists if and only if the value of fLoadRelId is 1.
namedRange (variable): An XLNameWideString (section 2.5.166) that specifies the defined name that is the source data. This field exists if and only if the value of fName is 1.
range (16 bytes): An UncheckedRfX (section 2.5.154) that specifies the range that is the source data. This field exists if and only if the value of fName is 0.