PivotChanges class

Office 2013 and later

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

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

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

2.6.39 CT_PivotChanges

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/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 (1) 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 (1) 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.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.
Show: