Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: Element
Name: reference
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Type: nsM:CT_PivotAreaReference
Containing Schema: sml-pivotTableShared.xsd
MinOccurs (1)
MaxOccurs unbounded
Abstract
Documentation:
Reference
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottableshared_xsd Drilldown into x in schema sml-pivottableshared_xsd Drilldown into varPSubtotal in schema sml-pivottableshared_xsd Drilldown into varSubtotal in schema sml-pivottableshared_xsd Drilldown into stdDevPSubtotal in schema sml-pivottableshared_xsd Drilldown into stdDevSubtotal in schema sml-pivottableshared_xsd Drilldown into countSubtotal in schema sml-pivottableshared_xsd Drilldown into productSubtotal in schema sml-pivottableshared_xsd Drilldown into minSubtotal in schema sml-pivottableshared_xsd Drilldown into maxSubtotal in schema sml-pivottableshared_xsd Drilldown into avgSubtotal in schema sml-pivottableshared_xsd Drilldown into countASubtotal in schema sml-pivottableshared_xsd Drilldown into sumSubtotal in schema sml-pivottableshared_xsd Drilldown into defaultSubtotal in schema sml-pivottableshared_xsd Drilldown into relative in schema sml-pivottableshared_xsd Drilldown into byPosition in schema sml-pivottableshared_xsd Drilldown into selected in schema sml-pivottableshared_xsd Drilldown into count in schema sml-pivottableshared_xsd Drilldown into field in schema sml-pivottableshared_xsd Drilldown into CT_PivotAreaReference in schema sml-pivottableshared_xsdXSD Diagram of reference in schema sml-pivottableshared_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:element name="reference" maxOccurs="unbounded" type="CT_PivotAreaReference">
    <xsd:annotation>
        <xsd:documentation>Reference</xsd:documentation>
    </xsd:annotation>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
x nsM:x 0 unbounded
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
field nsM:field Optional
count nsM:count (Optional)
selected nsM:selected true (Optional)
byPosition nsM:byPosition false (Optional)
relative nsM:relative false (Optional)
defaultSubtotal nsM:defaultSubtotal false (Optional)
sumSubtotal nsM:sumSubtotal false (Optional)
countASubtotal nsM:countASubtotal false (Optional)
avgSubtotal nsM:avgSubtotal false (Optional)
maxSubtotal nsM:maxSubtotal false (Optional)
minSubtotal nsM:minSubtotal false (Optional)
productSubtotal nsM:productSubtotal false (Optional)
countSubtotal nsM:countSubtotal false (Optional)
stdDevSubtotal nsM:stdDevSubtotal false (Optional)
stdDevPSubtotal nsM:stdDevPSubtotal false (Optional)
varSubtotal nsM:varSubtotal false (Optional)
varPSubtotal nsM:varPSubtotal false (Optional)
Collapse Derivation Tree:
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0