Definition Type: ComplexType
Name: CT_DataField
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTable.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottable_xsd Drilldown into numFmtId in schema sml-pivottable_xsd Drilldown into baseItem in schema sml-pivottable_xsd Drilldown into baseField in schema sml-pivottable_xsd Drilldown into showDataAs in schema sml-pivottable_xsd Drilldown into subtotal in schema sml-pivottable_xsd Drilldown into fld in schema sml-pivottable_xsd Drilldown into name in schema sml-pivottable_xsdXSD Diagram of CT_DataField in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_DataField">
    <xsd:sequence>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="name" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Data Field Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fld" type="xsd:unsignedInt" use="required">
        <xsd:annotation>
            <xsd:documentation>Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="subtotal" type="ST_DataConsolidateFunction" default="sum">
        <xsd:annotation>
            <xsd:documentation>Subtotal</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showDataAs" type="ST_ShowDataAs" default="normal">
        <xsd:annotation>
            <xsd:documentation>Show Data As Display Format</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="baseField" type="xsd:int" default="-1">
        <xsd:annotation>
            <xsd:documentation>'Show Data As' Base Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="baseItem" type="xsd:unsignedInt" default="1048832">
        <xsd:annotation>
            <xsd:documentation>'Show Data As' Base Setting</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional">
        <xsd:annotation>
            <xsd:documentation>Number Format Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
name nsM:name Optional
fld nsM:fld Required
subtotal nsM:subtotal sum (Optional)
showDataAs nsM:showDataAs normal (Optional)
baseField nsM:baseField -1 (Optional)
baseItem nsM:baseItem 1048832 (Optional)
numFmtId nsM:numFmtId Optional
Collapse Derivation Tree:
Collapse References:
nsM:dataField