[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

pivotArea (Pivot Area)

Rule describing a PivotTable selection.

Parent Elements

autoSortScope3.10.1.1); calculatedItem3.10.1.8); chartFormat3.10.1.12); format3.10.1.35); pivotAreas3.10.1.66); pivotSelection3.3.1.67)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

references (References)

§3.10.2.2

 

Attributes

Description

axis (Axis)

The region of the PivotTable to which this rule applies.

 

The possible values for this attribute are defined by the ST_Axis simple type (§3.18.1).

cacheIndex (Cache Index)

Flag indicating whether any indexes refer to fields or items in the Pivot cache and not the view.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

collapsedLevelsAreSubtotals (Collapsed Levels Are Subtotals)

Flag indicating if collapsed levels/dimensions are considered subtotals.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

dataOnly (Data Only)

Flag indicating whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

field (Field Index)

Index of the field that this selection rule refers to.

 

The possible values for this attribute are defined by the XML Schema int datatype.

fieldPosition (Field Position)

Position of the field within the axis to which this rule applies.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

grandCol (Include Column Grand Total)

Flag indicating whether the column grand total is included.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

grandRow (Include Row Grand Total)

Flag indicating whether the row grand total is included.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

labelOnly (Labels Only)

Flag indicating whether only the item labels for an item selection are selected and does not include the data values (in the data area of the view).

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

offset (Offset Reference)

A Reference that specifies a subset of the selection area. Points are relative to the top left of the selection area.

 

The possible values for this attribute are defined by the ST_Ref simple type (§3.18.64).

outline (Outline)

Flag indicating whether the rule refers to an area that is in outline mode.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

type (Rule Type)

Indicates the type of selection rule.

 

The possible values for this attribute are defined by the ST_PivotAreaType simple type (§3.18.60).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_PivotArea">

   <sequence>

   <element name="references" minOccurs="0" type="CT_PivotAreaReferences"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>

   </sequence>

   <attribute name="field" use="optional" type="xsd:int"/>

   <attribute name="type" type="ST_PivotAreaType" default="normal"/>

   <attribute name="dataOnly" type="xsd:boolean" default="true"/>

   <attribute name="labelOnly" type="xsd:boolean" default="false"/>

   <attribute name="grandRow" type="xsd:boolean" default="false"/>

   <attribute name="grandCol" type="xsd:boolean" default="false"/>

   <attribute name="cacheIndex" type="xsd:boolean" default="false"/>

   <attribute name="outline" type="xsd:boolean" default="true"/>

   <attribute name="offset" type="ST_Ref"/>

   <attribute name="collapsedLevelsAreSubtotals" type="xsd:boolean" default="false"/>

   <attribute name="axis" type="ST_Axis" use="optional"/>

   <attribute name="fieldPosition" type="xsd:unsignedInt" use="optional"/>

</complexType>