[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

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

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2011] 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.

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

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.

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

2.6.40 CT_PivotChange

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

Referenced by: CT_PivotChanges

A complex type 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.

Child Elements:

editValue: A CT_PivotEditValue element that specifies the value that replaces the original value in the OLAP data source (1) for the PivotTable what-if analysis.

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