PivotEditValue Class
Defines the PivotEditValue Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:editValue.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.OpenXmlLeafTextElement
DocumentFormat.OpenXml.Office2010.Excel.PivotEditValue
Namespace: DocumentFormat.OpenXml.Office2010.Excel
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class PivotEditValue _
Inherits OpenXmlLeafTextElement
'Usage
Dim instance As PivotEditValue
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class PivotEditValue : OpenXmlLeafTextElement
Remarks
2.6.42 CT_PivotEditValue
Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/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 ([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 for PivotTable what-if analysis.
Attributes:
valueType : An ST_PivotEditValueType attribute 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. MUST NOT be equal to deleted.
The length of the string MUST be greater than 0 and MUST be less than 32768 characters.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
<xsd:complexType name="CT_PivotEditValue">
<xsd:simpleContent>
<xsd:extension base="x:ST_Xstring">
<xsd:attribute name="valueType" use="required" type="ST_PivotEditValueType"/>
</xsd:extension>
</xsd:simpleContent>
</xsd:complexType>
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Thread Safety
Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.