PivotChanges Class

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

Inheritance Hierarchy

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

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

Syntax

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

Remarks

The following table lists the possible child types:

  • PivotChange <x14:pivotChange>

2.6.39 CT_PivotChanges

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

Referenced by: CT_PivotTableDefinition

A complex type that specifies the values used for PivotTable what-if analysis calculations and specifies the allocation methods for how to apply the values. It also specifies the collections of MDX unique names that identify the original values in the OLAP data source that were changed.

Child Elements:

pivotChange : A CT_PivotChange element that specifies the value used for PivotTable what-if analysis calculation and specifies the allocation method for how to apply the value. It also specifies a collection of MDX unique names that identifies the original value in the OLAP data source that was changed.

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

<xsd:complexType name="CT_PivotChanges">

<xsd:sequence>

<xsd:element name="pivotChange" minOccurs="1" maxOccurs="unbounded" type="CT_PivotChange"/>

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

PivotChanges Members

DocumentFormat.OpenXml.Office2010.Excel Namespace