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

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_QueryTable element (section 2.6.88) that specifies extended properties of a query table ([ISO/IEC29500-1:2011] section 18.12).

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

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

2.4.42 webExtensions

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_WebExtensions element that specifies a group of CT_WebExtension elements that specify Bindings on the Web Extensions, as specified by [MS-OWEXML] section 1.3, on the worksheet.

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

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

2.4.43 connection

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_Connection element that specifies the extended properties of an external connection.

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

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

2.4.44 calculatedMember

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_CalculatedMemberExt

A CT_CalculatedMember (section 2.6.93) element that specifies a definition for a custom member or measure that is applied to a pivot table.

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

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

2.4.45 pivotTableUISettings

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_PivotTableUISettings element that specifies state of the PivotTable field list for this PivotTable ([ISO/IEC29500-1:2011] section 18.10).

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

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

2.4.46 pivotFilter

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_PivotFilter element that specifies the extended properties of a filter (PivotTable Advanced Filter), as specified in ([ISO/IEC29500-1:2011] section 18.10.1.33). See section 2.2.4.4 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2011].

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

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

2.4.47 slicerCaches

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

A CT_SlicerCaches element that specifies a group of slicer cache, as specified in section 2.1.4, identifiers for the workbook.

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

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

2.4.48 tableSlicerCache