Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

2.4.86 DConRef

Office

The DConRef record specifies a range in this workbook or in an external workbook that is a data source (1) for a PivotTable or a data source (1) 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.