PivotEditValue class

Office 2013 and later

Defines the PivotEditValue Class.This class is available in Office2010 or above. When the object is serialized out as xml, its qualified name is x14:editValue.

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class PivotEditValue : OpenXmlLeafTextElement

2.6.42 CT_PivotEditValue

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main

Referenced by: CT_PivotUserEdit, CT_PivotChange

A complex type that specifies the value type of the user input in the single cell of the PivotTable, as specified in [ISO/IEC-29500-1] section 18.10, data area, or value type of the value that replaces the original value in the OLAP data source (1) for PivotTable what-if analysis, as specified in section 2.3.1.


valueType: An ST_PivotEditValueType attribute, as specified in section 2.7.11, that specifies the type of the value of the user input or the type of the value that replaces the original value in the OLAP data source (1). MUST NOT be equal to "deleted".

The length of the string MUST be greater than zero and MUST be less than 32,768 characters.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_PivotEditValue">


<xsd:extension base="x:ST_Xstring">

<xsd:attribute name="valueType" use="required" type="ST_PivotEditValueType"/>




See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

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