[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

field (Field)

Represents a generic field that can appear either on the column or the row region of the PivotTable. There will be as many <x> elements as there are item values in any particular column or row.


<sh:field x="2"/>

end example]

Parent Elements

colFields3.10.1.14); rowFields3.10.1.81)




x (Field Index)

Specifies the index to a pivotField item value. There will be as many x elements as there are item values in any particular column. Note that these x elements sometimes are not explicitly written, but instead "inherited" from the previous column or i element, via the value of @r. The pivotField items don't list values explicitly, but instead reference a shared item value in the pivotCacheDefinition part. The first instance of x has no attribute value @v associated with it, so the default value for @v is assumed to be "0".


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

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

<complexType name="CT_Field">

   <attribute name="x" type="xsd:int" use="required"/>