[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
Represents the set of selected fields and the selected items within those fields.
[Example:
<sh:references count="5">
<sh:reference field="4294967294" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="2" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="14" count="1" selected="0">
<sh:x v="0"/>
</sh:reference>
<sh:reference field="15" count="2" selected="0">
<sh:x v="2"/>
<sh:x v="3"/>
</sh:reference>
</sh:references>
end example]
Parent Elements |
pivotArea (§3.3.1.66) |
Child Elements |
Subclause |
reference (Reference) |
§3.10.2.1 |
Attributes |
Description |
count (Pivot Filter Count) |
Specifies the number of filtered records available in the PivotTable.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_PivotAreaReferences">
<sequence>
<element name="reference" maxOccurs="unbounded" type="CT_PivotAreaReference"/>
</sequence>
<attribute name="count" type="xsd:unsignedInt"/>
</complexType>