2.4.86 DConRef

Office

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.


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

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. 

Show: