Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: SimpleType
Name: ST_DataConsolidateFunction
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Documentation:
Data Consolidation Functions
Collapse XSD Schema Diagram:
XSD Diagram of ST_DataConsolidateFunction in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:simpleType name="ST_DataConsolidateFunction">
    <xsd:annotation>
        <xsd:documentation>Data Consolidation Functions</xsd:documentation>
    </xsd:annotation>
    <xsd:restriction base="xsd:string">
        <xsd:enumeration value="average">
            <xsd:annotation>
                <xsd:documentation>Average</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="count">
            <xsd:annotation>
                <xsd:documentation>Count</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="countNums">
            <xsd:annotation>
                <xsd:documentation>CountNums</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="max">
            <xsd:annotation>
                <xsd:documentation>Maximum</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="min">
            <xsd:annotation>
                <xsd:documentation>Minimum</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="product">
            <xsd:annotation>
                <xsd:documentation>Product</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="stdDev">
            <xsd:annotation>
                <xsd:documentation>StdDev</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="stdDevp">
            <xsd:annotation>
                <xsd:documentation>StdDevP</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="sum">
            <xsd:annotation>
                <xsd:documentation>Sum</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="var">
            <xsd:annotation>
                <xsd:documentation>Variance</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
        <xsd:enumeration value="varp">
            <xsd:annotation>
                <xsd:documentation>VarP</xsd:documentation>
            </xsd:annotation>
        </xsd:enumeration>
    </xsd:restriction>
</xsd:simpleType>
Collapse Facets:
Facet Value
Enumeration average
Enumeration count
Enumeration countNums
Enumeration max
Enumeration min
Enumeration product
Enumeration stdDev
Enumeration stdDevp
Enumeration sum
Enumeration var
Enumeration varp
Collapse Derivation Tree:
Collapse References:
nsM:functionnsM:subtotal,
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0