Export (0) Print
Expand All

Field class

Row Items. When the object is serialized out as xml, its qualified name is x:field.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class Field : OpenXmlLeafElement

[ISO/IEC 29500-1 1st Edition]

field (Field)

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

[Example:

<sh:field x="2"/>

end example]

Parent Elements

colFields (§18.10.1.14); rowFields (§18.10.1.81)

Attributes

Description

x (Field Index)

Specifies the index to a pivotField item value. There are 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 W3C XML Schema int datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_Field) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Community Additions

Show:
© 2014 Microsoft