Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: SourceConsolidationType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the properties of a consolidation data source.
Collapse XSD Schema Diagram:
Drilldown into NoAutoPage in schema excel_xsd Drilldown into Reference in schema excel_xsdXSD Diagram of SourceConsolidationType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="SourceConsolidationType">
    <xsd:annotation>
        <xsd:documentation>Contains the properties of a consolidation data source.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="Reference" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains the properties of a consolidation reference when in a SourceConsolidation element, or a cell range when in the ConsolidationReference element.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element name="ConsolidationReference" type="ConsolidationReferenceType">
                        <xsd:annotation>
                            <xsd:documentation>Contains the properties of a range data source.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Item" type="xsd:string" minOccurs="0" maxOccurs="4">
                        <xsd:annotation>
                            <xsd:documentation>Contains the name of a child item in a PivotTable field, or the index number of an item described by the PTLineItem element.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                </xsd:sequence>
            </xsd:complexType>
        </xsd:element>
        <xsd:element name="NoAutoPage" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether page fields are created automatically for a consolidation.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Reference x:Reference (1) unbounded
NoAutoPage x:NoAutoPage 0 (1)
Collapse Derivation Tree:
Collapse References:
x:SourceConsolidation
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0