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

altTextSummary: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the alternate text summary for the table. The string MUST be less than or equal to 50,000 characters in length.

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

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

2.6.37 CT_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:2011] section 18.10) data area. It also specifies the collections of MDX unique names that identify the values in the OLAP data source (1), and specifies the PivotTable ([ISO/IEC29500-1:2011] section 18.10) rules that can be used to identify the cells in the PivotTable ([ISO/IEC29500-1:2011] 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:2011] section 18.10) data area, and specifies the collection of MDX unique names that identifies the value in the OLAP data source (1), and 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.

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.38 CT_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:2011] 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:2011] 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 (1) that was changed using PivotTable what-if analysis.