[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
dataRef (Data Consolidation Reference)
A single data consolidate reference. One dataRef shall use either name or sheet & ref, but not both on the same dataRef.
|
Parent Elements |
|
dataRefs (§3.3.1.29) |
|
Attributes |
Description |
|
id (relationship Id)
Namespace: .../officeDocument/2006/relationships |
Used only when the source range is external to this workbook.
The possible values for this attribute are defined by the ST_RelationshipId simple type (§7.8.2.1). |
|
name (Named Range) |
Named range, either in this workbook or the external workbook referenced by r:Id.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
ref (Reference) |
Cell range.
The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64). |
|
sheet (Sheet Name) |
Sheet name.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_DataRef">
<attribute name="ref" type="ST_Ref" use="optional"/>
<attribute name="name" type="ST_Xstring" use="optional"/>
<attribute name="sheet" type="ST_Xstring" use="optional"/>
<attribute ref="r:id" use="optional"/>
</complexType>