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

1531.1.1CT_CfIcon

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

Referenced by: CT_IconSet

A complex type that specifies a single icon of an icon set.

Attributes:

iconSet: An ST_IconSetType attribute that specifies the icon set.

iconId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the icon to be used. If the icon set specified by iconSet has three icons, this value MUST be less than or equal to 2. If the icon set specified by iconSet has four icons, this value MUST be less than or equal to 3. If the icon set specified by iconSet has five icons, this value MUST be less than or equal to 4. If iconSet equals "NoIcons", this value MUST be 0.

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

1532

1533

1534

1535

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

1535.1.1CT_PivotEdits

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

Referenced by: CT_PivotTableDefinition

A complex type that specifies user inputs related to PivotTable what-if analysis in single cells of the PivotTable ([ISO/IEC29500-1:2012] section 18.10) data area. It also specifies the collections of MDX unique names that identify the values in the OLAP data source, and specifies the PivotTable ([ISO/IEC29500-1:2012] section 18.10) rules that can be used to identify the cells in the PivotTable ([ISO/IEC29500-1:2012] section 18.10) data area.

Child Elements:

pivotEdit: A CT_PivotEdit element 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, and specifies the collection of MDX unique names that identifies the value in the OLAP data source, and specifies a PivotTable ([ISO/IEC29500-1:2012] section 18.10) rule that can be used to identify the cell in 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.

1536

1537

1538

1539

1540

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

1540.1.1CT_PivotEdit

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/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/IEC29500-1:2012] 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/IEC29500-1:2012] 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/IEC29500-4:2012] section A.2) element that specifies a PivotTable ([ISO/IEC29500-1:2012] section 18.10) rule that can be used to identify the cell in the PivotTable ([ISO/IEC29500-1:2012] section 18.10) data area.

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

1541

1542

1543

1544

1545

1546

1547

1548

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

1548.1.1CT_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 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.

1549

1550

1551

1552

1553

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