Contains the properties of a consolidation data source.
Namespace | urn:schemas-microsoft-com:office:excel |
Schema name | XML Spreadsheet 2000 |
Element | Description |
---|---|
Reference | Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element. |
ConsolidationReference | Contains the properties of a range data source. |
Item | Contains the name of a child item in a PivotTable field, or the index number of an item described by the PTLineItem element. |
NoAutoPage | Specifies whether page fields are created automatically for a consolidation. |
None.
<xsd:complexType name="SourceConsolidationType" >
<xsd:sequence>
<xsd:element name="Reference" maxOccurs="unbounded">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ConsolidationReference" type="ConsolidationReferenceType">
</xsd:element>
<xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="4">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="NoAutoPage" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>