Definition Type: Element
Name: pivotArea
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_PivotArea
Containing Schema: sml-pivotTable.xsd
MinOccurs (1)
MaxOccurs (1)
Abstract
Documentation:
Calculated Item Location
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_xsd Drilldown into CT_PivotArea in schema sml-pivottableshared_xsdXSD Diagram of pivotArea in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:element name="pivotArea" type="CT_PivotArea">
    <xsd:annotation>
        <xsd:documentation>Calculated Item Location</xsd:documentation>
    </xsd:annotation>
</xsd:element>
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: