[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

reference (Reference)

Represents a set of selected fields and selected items within those fields.

[Example:

<sh:reference field="4294967294" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>

end example]

Parent Elements

references3.10.2.2)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

x (Shared Items Index)

§3.10.1.97

 

Attributes

Description

avgSubtotal (Include Average Filter)

Specifies a boolean value that indicates whether the 'average' aggregate function is included in the filter.

 

A value of on, 1, or true indicates the average aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

byPosition (Positional Reference)

Specifies a boolean value that indicates whether the item is referred to by position rather than item index.

 

A value of on, 1, or true indicates the item is referred to by position.

 

A value of off, 0, or false indicates the item is referred to by index.

 

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

count (Item Index Count)

Specifies the number of item indexes in the collection of indexes (x tags).

 

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

countASubtotal (Include CountA Filter)

Specifies a boolean value that indicates whether the 'countA' subtotal is included in the filter.

 

A value of on, 1, or true indicates the count aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

countSubtotal (Include Count Subtotal)

Specifies a boolean value that indicates whether the count aggregate function is included in the filter.

 

A value of on, 1, or true indicates the count aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

defaultSubtotal (Include Default Filter)

Specifies a boolean value that indicates whether the default subtotal is included in the filter.

 

A value of on, 1, or true indicates the default subtotal will is included in the filter. The default is to display the total or the grand total.

 

A value of off, 0, or false indicates another subtotal or aggregation function is included in the filter.

 

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

field (Field Index)

Specifies the index of the field to which this filter refers. A value of -2 indicates the 'data' field.

 

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

maxSubtotal (Include Maximum Filter)

Specifies a boolean value that indicates whether the 'maximum' aggregate function is included in the filter.

 

A value of on, 1, or true indicates the maximum aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

minSubtotal (Include Minimum Filter)

Specifies a boolean value that indicates whether the 'minimum' aggregate function is included in the filter.

 

A value of on, 1, or true indicates the minimum aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

productSubtotal (Include Product Filter)

Specifies a boolean value that indicates whether the 'product' aggregate function is included in the filter.

 

A value of on, 1, or true indicates the product aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

relative (Relative Reference)

Specifies a boolean value that indicates whether the item is referred to by a relative reference rather than an absolute reference. This attribute is used if posRef is set to true.

 

A value of on, 1, or true indicates the item is referred to by a relative reference.

 

A value of off, 0, or false indicates the item is referred to by an absolute reference.

 

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

selected (Selected)

Specifies a boolean value that indicates whether this field has selection. This attribute is used when the PivotTable is in Outline view. It is also used when both header and data cells have selection.

 

A value of on, 1, or true indicates the field has selection.

 

A value of off, 0, or false indicates the field does not have selection.

 

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

stdDevPSubtotal (Include StdDevP Filter)

Specifies a boolean value that indicates whether the population standard deviation aggregate function is included in the filter.

 

A value of on, 1, or true indicates the population standard deviation aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

stdDevSubtotal (Include StdDev Filter)

Specifies a boolean value that indicates whether the standard deviation aggregate function is included in the filter.

 

A value of on, 1, or true indicates the standard deviation aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

sumSubtotal (Include Sum Filter)

Specifies a boolean value that indicates whether the sum aggregate function is included in the filter.

 

A value of on, 1, or true indicates the sum aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

varPSubtotal (Include VarP Filter)

Specifies a boolean value that indicates whether the population variance aggregate function is included in the filter.

 

A value of on, 1, or true indicates the population variance aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

varSubtotal (Include Var Filter)

Specifies a boolean value that indicates whether the variance aggregate function is included in the filter.

 

A value of on, 1, or true indicates the variance aggregation function will is included in the filter.

 

A value of off, 0, or false indicates another aggregation function is included in the filter.

 

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

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

<complexType name="CT_PivotAreaReference">

   <sequence>

   <element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_Index"/>

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

   </sequence>

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

   <attribute name="count" type="xsd:unsignedInt"/>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

</complexType>