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

hideValuesRow: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the values row (2) in the PivotTable ([ISO/IEC29500-1:2011] section 18.10) report is visible.

Value	Meaning
"false"	The values row (2) in the PivotTable ([ISO/IEC29500-1:2011] section 18.10) report is visible.
"true"	The values row (2) in the PivotTable ([ISO/IEC29500-1:2011] section 18.10) report is not visible.

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.33 CT_PivotCacheDefinition

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

Referenced by: pivotCacheDefinition

A complex type that specifies the extended properties of a PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache definition.

Attributes:

slicerData: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the Slicer Cache Relationship to PivotCache. MUST be "true" if the OLAP PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache definition is being referenced by a slicer cache.

pivotCacheId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute which uniquely identifies this PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache. The value MUST be greater than or equal to zero. The value MUST NOT be zero if there is a slicer cache that uses this PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache as a data source (1), or if there is a CT_PivotCacheIdVersion element that is preceded by this element.

supportSubqueryNonVisual: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable ([ISO/IEC29500-1:2011] section 18.10) supports hidden PivotTable items.

supportSubqueryCalcMem: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the OLAP source data of this PivotTable supports PivotTable calculated members in an OLAP subselect for filtering.

Value	Meaning
"true"	The OLAP source data of this PivotTable supports PivotTable calculated members in an OLAP subselect for filtering.
"false"	The OLAP source data of this PivotTable does not support PivotTable calculated members in an OLAP subselect for filtering.

supportAddCalcMems: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether PivotTable ([ISO/IEC29500-1:2011] section 18.10) calculated members are shown for filtering.

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.34 CT_Connection

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

Referenced by: connection

A complex type that specifies the extended properties of an external connection ([ISO/IEC29500-1:2011] section 18.13).

Child Elements:

calculatedMembers: A CT_CalculatedMembers ([ISO/IEC29500-4:2011] section A.2) element that specifies a list of PivotTable ([ISO/IEC29500-1:2011] section 18.10) OLAP-calculated members associated with this external connection ([ISO/IEC29500-1:2011] section 18.13). If this external connection ([ISO/IEC29500-1:2011] section 18.13) is associated with a PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache, the list MUST NOT exist. If this element exists, the ancestor CT_connection ([ISO/IEC29500-4:2011] section A.2) element of this element MUST have a child CT_OlapPr ([ISO/IEC29500-1:2011] section 18.13.5) element.

Attributes:

culture: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the language associated with this external connection ([ISO/IEC29500-1:2011] section 18.13). The length of this string MUST be less than 85 characters. If the length of this string is greater than 0, the contents of this string MUST<13> be a language tag as specified by [RFC3066]. If this attribute is not present, the data connection is using the server language.

embeddedDataId: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies an embedded Custom Data part. The length of this value MUST be less than 65,536 characters. If the length of this string is greater than 0, the contents of this string MUST be equal to the id attribute of a CT_DatastoreItem element, in a Custom Data Properties part in this package ([ISO/IEC29500-1:2011] section 9).

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.35 CT_Table

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

Referenced by: table

A complex type that specifies alternate text properties for the table.

Attributes:

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

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.

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.

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

weightExpression: An ST_Xstring ([ISO/IEC29500-1:2011] 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.

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

2.6.41 CT_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:2011] 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: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.42 CT_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:2011] section 18.10, data area, or value type of the value that replaces the original value in the OLAP data source (1) 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 (1).

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.

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

2.6.43 CT_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 (1) 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:2011] 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.

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

2.6.44 CT_SlicerStyle

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

Referenced by: CT_SlicerStyles

CT_SlicerStyle specifies table style elements, as specified in [ISO/IEC29500-1:2011] section 18.8, of the slicer style, as specified in section 2.3.2.4, that are specific to slicers, as specified in section 2.3.2.

Child Elements:

slicerStyleElements: A CT_SlicerStyleElements, as specified in section 2.6.52, that specifies table style elements of the slicer style that are specific to slicers. There MUST NOT be more than one CT_SlicerStyleElements in this element.

Attributes:

name: A string attribute, as specified in [XMLSCHEMA2] section 3.2.1, that specifies the name of the user-defined table style that this slicer style is based upon. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters. This string MUST be unique within the CT SlicerStyle elements in the Styles part, as specified in [ISO/IEC29500-1:2011] section 12.3.20. This string MUST match the name attribute of a CT_TableStyle element, as specified in [ISO/IEC29500-4:2011] section A.2, in the Styles part. In the CT_TableStyle element with a name attribute that matches this string, the pivot attribute MUST equal "false" and the table attribute MUST equal "false".

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.45 CT_SlicerStyleElement

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

Referenced by: CT_SlicerStyleElements

A complex type that specifies a table style element, as specified in [ISO/IEC29500-1:2011] section 18.8, of a slicer style, as specified in section 2.3.2.4.

Attributes: