[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_PivotCacheIdVersion element that specifies the extended properties of a PivotTable ([ISO/IEC29500-1:2011] section 18.10) PivotCache Definition. If this element exists, there MUST be a preceding CT_PivotCacheDefinition element and the pivotCacheId attribute of the preceding CT_PivotCacheDefinition element MUST be equal to one of the following:-

 The cacheId attribute of the CT_PivotTableData element in the PivotTable part that specifies a Non-Worksheet PivotTable.

 The pivotCacheId attribute of the CT_TimelineState (section 2.6.116) child element of a CT_TimelineCacheDefinition (section 2.6.112) element that specifies a Timeline cache.

See section 2.2.4.5 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.66 timeslicer

Target namespace: http://schemas.microsoft.com/office/drawing/2012/timeslicer

A CT_Timeline element that specifies which timeline view is associated with this drawing element.

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

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

2.4.67 list

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2011/1/ac

An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) element that specifies the first formula in the DataValidation dropdown used for custom or list type data validation. Only used when items need to be quoted.

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

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

2.4.68 absPath

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

A CT_AbsolutePath element that specifies the absolute path to the workbook.

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

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

2.4.69 dataField

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

A dataField element is a CT_DataField type element, as specified in section 2.6.25, that specifies extended information about a PivotTable, as specified in [ISO/IEC29500-1:2011] section 18.10, data field (1) item. 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.70 survey

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

A survey element is a CT_Survey type element, as specified in section 2.6.143, that specifies the properties of a survey associated with a Table ([ISO/IEC29500-1:2011] section 18.5). This element is the root element of the Survey part (section 2.1.9)

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.71 contentPart

Target namespace: http://schemas.microsoft.com/office/excel/2010/spreadsheetDrawing

A CT_ContentPart element that specifies [TYPE HERE]

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

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

2.5 Global Attributes

2.5.1 dyDescent

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

The dyDescent attribute is a double attribute, as specified in [XMLSCHEMA2] section 3.2.5, that specifies the vertical distance in pixels from the bottom of the cells in the current row (2) to the typographical baseline of the cell content if, hypothetically, the zoom level for the sheet (1) containing this row (2) is 100 percent and the cell has bottom-alignment formatting. See section 2.2.4.11 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 attribute.

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

2.5.2 knownFonts

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

The knownFonts attribute is a Boolean attribute, as specified in ([XMLSCHEMA2] section 3.2.2, that specifies the typographical descent information that is stored in the workbook. See section 2.2.4.7 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 attribute.

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

2.6 Complex Types

2.6.1 CT_ConditionalFormattings

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

Referenced by: conditionalFormattings

The CT_ConditionalFormattings complex type specifies conditional formatting information for the worksheet.

Child Elements: