2.4.86 DConRef
The DConRef record specifies a range in this workbook or in an external workbook that is a data source for a PivotTable or a data source for the data consolidation settings of the associated sheet. If the range specified is in an external workbook this record also specifies the path to the external workbook.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
ref |
|||||||||||||||||||||||||||||||
|
... |
cchFile |
||||||||||||||||||||||||||||||
|
stFile (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
unused (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
ref (6 bytes): A RefU structure that specifies the range. If this record is part of an SXTBL production as specified in the Globals Substream ABNF and this field has a rwFirst equal to 0 and a rwLast equal to 16383, this reference specifies all rows within the columns specified by colFirst and colLast.
cchFile (2 bytes): An unsigned integer that specifies the count of characters in stFile. MUST be greater than or equal to 0x0002.
stFile (variable): A DConFile structure that specifies the workbook and sheet that contains the range specified in the ref field.
unused (variable): An array of bytes that is unused and MUST be ignored. MUST exist if and only if stFile specifies a self reference (the value of stFile.stFile.rgb[0] is 2). If the value stFile.stFile.fHighByte is 0 the size of this array is 1. If the value of stFile.stFile.fHighByte is 1 the size of this array is 2.