[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

cacheFields (PivotCache Fields)

Represents the collection of field definitions in the source data.

[Example:

<cacheFields count="1">
<cacheField name="Group" numFmtId="0">
<sharedItems count="3">
<s v="One"/>
<s v="Two"/>
<s v="Three"/>
</sharedItems>
</cacheField>
</cacheFields>

end example]

Parent Elements

pivotCacheDefinition3.10.1.67)

 

Child Elements

Subclause

cacheField (PivotCache Field)

§3.10.1.3

 

Attributes

Description

count (Field Count)

Specifies the number of fields in the cache.

 

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_CacheFields">

   <sequence>

   <element name="cacheField" type="CT_CacheField" minOccurs="0" maxOccurs="unbounded"/>

   </sequence>

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

</complexType>