[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format Intellectual Property Rights Notice for Open Specifications Documentation

1553.1.1CT_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 that was changed.

Child Elements:

editValue: A CT_PivotEditValue element that specifies the value that replaces the original value in the OLAP data source 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 that was changed using PivotTable what-if analysis.

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

Attributes:

allocationMethod: An ST_AllocationMethod attribute that specifies the allocation method, used by PivotTable what-if analysis, to change the value in the OLAP data source.

weightExpression: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the OLAP weight expression for PivotTable what-if analysis. The weightExpression MUST NOT exist if allocationMethod equals equalAllocation or equals equalIncrement. The weightExpression MUST be greater than or equal to 0 and less than or equal to 65,535 characters in length.

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

1554

1555

1556

1557

1558

1559

1560

1561

1562

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

1562.1.1CT_PivotUserEdit

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

Referenced by: CT_PivotEdit

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

Child Elements:

xm:f: An f element that specifies a formula. The formula MUST adhere to the grammar provided in Formulas, with the following restriction: The formula MUST NOT use the bang-reference or bang-name production rules.

editValue: A CT_PivotEditValue element that specifies the user input value that replaces the original cell value, in a single cell of the PivotTable ([ISO/IEC29500-1:2012] section 18.10) data area.

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

1563

1564

1565

1566

1567

1568

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

1568.1.1CT_PivotEditValue

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/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, as specified in [ISO/IEC29500-1:2012] 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, as specified in section 2.3.1.

Attributes:

valueType: An ST_PivotEditValueType attribute, as specified in section 2.7.11, 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.

The length of the string MUST be greater than zero and MUST be less than 32,768 characters.

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

1569

1570

1571

1572

1573

1574

1575

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

1575.1.1CT_TupleItems

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

Referenced by: CT_PivotEdit, CT_PivotChange

A complex type that specifies the MDX unique names that identify the value in the OLAP data source using PivotTable what-if analysis, as specified in section 2.3.1.

Child Elements:

tupleItem: An ST_Xstring element, as specified in [ISO/IEC29500-1:2012] section 22.9.2.19, that specifies an MDX unique name. The number of these elements MUST be greater than zero and MUST be less than 2^31. The length of each ST_Xstring MUST be greater than zero and MUST be less than or equal to 65,535 characters.

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

1576

1577

1578

1579

1580

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