Definition Type: ComplexType
Name: CT_CalculatedItem
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 pivotArea in schema sml-pivottable_xsd Drilldown into formula in schema sml-pivottable_xsd Drilldown into field in schema sml-pivottable_xsdXSD Diagram of CT_CalculatedItem in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_CalculatedItem">
    <xsd:sequence>
        <xsd:element name="pivotArea" type="CT_PivotArea">
            <xsd:annotation>
                <xsd:documentation>Calculated Item Location</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <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="field" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Field Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formula" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Calculated Item Formula</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
pivotArea nsM:pivotArea (1) (1)
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
field nsM:field Optional
formula nsM:formula (Optional)
Collapse Derivation Tree:
Collapse References:
nsM:calculatedItem