Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_PivotArea
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTableShared.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottableshared_xsd Drilldown into references in schema sml-pivottableshared_xsd Drilldown into fieldPosition in schema sml-pivottableshared_xsd Drilldown into axis in schema sml-pivottableshared_xsd Drilldown into collapsedLevelsAreSubtotals in schema sml-pivottableshared_xsd Drilldown into offset in schema sml-pivottableshared_xsd Drilldown into outline in schema sml-pivottableshared_xsd Drilldown into cacheIndex in schema sml-pivottableshared_xsd Drilldown into grandCol in schema sml-pivottableshared_xsd Drilldown into grandRow in schema sml-pivottableshared_xsd Drilldown into labelOnly in schema sml-pivottableshared_xsd Drilldown into dataOnly in schema sml-pivottableshared_xsd Drilldown into type in schema sml-pivottableshared_xsd Drilldown into field in schema sml-pivottableshared_xsdXSD Diagram of CT_PivotArea in schema sml-pivottableshared_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_PivotArea">
    <xsd:sequence>
        <xsd:element name="references" minOccurs="0" type="CT_PivotAreaReferences">
            <xsd:annotation>
                <xsd:documentation>References</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" use="optional" type="xsd:int">
        <xsd:annotation>
            <xsd:documentation>Field Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="type" type="ST_PivotAreaType" default="normal">
        <xsd:annotation>
            <xsd:documentation>Rule Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dataOnly" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Data Only</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="labelOnly" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Labels Only</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="grandRow" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Row Grand Total</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="grandCol" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Include Column Grand Total</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="cacheIndex" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Cache Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outline" type="xsd:boolean" default="true">
        <xsd:annotation>
            <xsd:documentation>Outline</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="offset" type="ST_Ref">
        <xsd:annotation>
            <xsd:documentation>Offset Reference</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="collapsedLevelsAreSubtotals" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Collapsed Levels Are Subtotals</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="axis" type="ST_Axis" use="optional">
        <xsd:annotation>
            <xsd:documentation>Axis</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fieldPosition" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Field Position</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
references nsM:references 0 (1)
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
field nsM:field Optional
type nsM:type normal (Optional)
dataOnly nsM:dataOnly true (Optional)
labelOnly nsM:labelOnly false (Optional)
grandRow nsM:grandRow false (Optional)
grandCol nsM:grandCol false (Optional)
cacheIndex nsM:cacheIndex false (Optional)
outline nsM:outline true (Optional)
offset nsM:offset (Optional)
collapsedLevelsAreSubtotals nsM:collapsedLevelsAreSubtotals false (Optional)
axis nsM:axis Optional
fieldPosition nsM:fieldPosition Optional
Collapse Derivation Tree:
Collapse References:
nsM:pivotArea, nsM:pivotArea, nsM:pivotArea, nsM:pivotArea, nsM:pivotArea, nsM:pivotArea
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0