Definition Type: Element
Name: Aggregate
Namespace: http://schemas.microsoft.com/office/excel/2003/xml
Type: string:http://www.w3.org/2001/XMLSchema
Containing Schema: excel2003xml.xsd
MinOccurs 0
MaxOccurs (1)
Abstract
ContentType Restriction
Default None
Documentation:
Indicates the kind of aggregation to be done in the totals row.
Collapse XSD Schema Diagram:
XSD Diagram of Aggregate in schema excel2003xml_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code:
<xsd:element name="Aggregate" minOccurs="0" default="None">
    <xsd:annotation>
        <xsd:documentation>Indicates the kind of aggregation to be done in the totals row.</xsd:documentation>
    </xsd:annotation>
    <xsd:simpleType>
        <xsd:restriction base="xsd:string">
            <xsd:enumeration value="None" />
            <xsd:enumeration value="Sum" />
            <xsd:enumeration value="Count" />
            <xsd:enumeration value="CountNums" />
            <xsd:enumeration value="Var" />
            <xsd:enumeration value="Average" />
            <xsd:enumeration value="stdDev" />
            <xsd:enumeration value="Max" />
            <xsd:enumeration value="Min" />
        </xsd:restriction>
    </xsd:simpleType>
</xsd:element>
Collapse Facets:
Facet Value
Enumeration None
Enumeration Sum
Enumeration Count
Enumeration CountNums
Enumeration Var
Enumeration Average
Enumeration stdDev
Enumeration Max
Enumeration Min