PivotEdit Class

Defines the PivotEdit Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:pivotEdit.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.PivotEdit

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

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(PivotUserEdit), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(TupleItems), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(PivotArea), FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(ExtensionList), FileFormatVersions.Office2010)> _
Public Class PivotEdit _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As PivotEdit
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(PivotUserEdit), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(TupleItems), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(PivotArea), FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(ExtensionList), FileFormatVersions.Office2010)]
public class PivotEdit : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • PivotUserEdit <x14:userEdit>

  • TupleItems <x14:tupleItems>

  • PivotArea <x14:pivotArea>

  • ExtensionList <x14:extLst>

2.6.38 CT_PivotEdit

Target namespace: https://schemas.microsoft.com/office/spreadsheetml/2010/main

Referenced by: CT_PivotEdits

A complex type that specifies user input, related to PivotTable what-if analysis, in a single cell of the PivotTable ([ISO/IEC-29500-1] section 18.10) data area.

Child Elements:

userEdit : A CT_PivotUserEdit element that specifies the user input value or formula that replaces the original cell value, in a single cell of the PivotTable ([ISO/IEC-29500-1] section 18.10) data area*.*

tupleItems : A CT_TupleItems element that specifies the MDX unique names that identify the value in the OLAP data source that was changed using PivotTable what-if analysis.

pivotArea : A CT_PivotArea ([ISO/IEC-29500-4] section A.2) element that specifies a PivotTable ([ISO/IEC-29500-1] section 18.10) rule that can be used to identify the cell in the PivotTable ([ISO/IEC-29500-1] section 18.10) data area.

extLst : A CT_ExtensionList ([ISO/IEC-29500-4] section A.2) that specifies future extensibility for this element.

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

<xsd:complexType name="CT_PivotEdit">

<xsd:sequence>

<xsd:element name="userEdit" type="CT_PivotUserEdit" minOccurs="1" maxOccurs="1"/>

<xsd:element name="tupleItems" type="CT_TupleItems" minOccurs="1" maxOccurs="1"/>

<xsd:element name="pivotArea" type="x:CT_PivotArea" minOccurs="1" maxOccurs="1"/>

<xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

</xsd:sequence>

</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.

See Also

Reference

PivotEdit Members

DocumentFormat.OpenXml.Office2010.Excel Namespace