Definition Type: ComplexType
Name: CT_DataConsolidate
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into dataRefs in schema sml-sheet_xsd Drilldown into link in schema sml-sheet_xsd Drilldown into topLabels in schema sml-sheet_xsd Drilldown into leftLabels in schema sml-sheet_xsd Drilldown into function in schema sml-sheet_xsdXSD Diagram of CT_DataConsolidate in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_DataConsolidate">
    <xsd:sequence>
        <xsd:element name="dataRefs" type="CT_DataRefs" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Data Consolidation References</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="function" type="ST_DataConsolidateFunction" use="optional" default="sum">
        <xsd:annotation>
            <xsd:documentation>Function Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="leftLabels" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Use Left Column Labels</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="topLabels" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Labels In Top Row</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="link" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Link</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
dataRefs nsM:dataRefs 0 1
Collapse Child Attributes:
Name Type Default Value Use
function nsM:function sum Optional
leftLabels nsM:leftLabels false Optional
topLabels nsM:topLabels false Optional
link nsM:link false Optional
Collapse Derivation Tree:
Collapse References:
nsM:dataConsolidate, nsM:dataConsolidate