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

2035.1.1CT_TimelineCacheDefinition

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

Referenced by: timelineCacheDefinition

A complex type that specifies a Timeline cache.

Child Elements:

pivotTables: A CT_TimelineCachePivotTables element (section 2.6.113) that specifies a group of CT_ TimelineCachePivotTable elements (section 2.6.114) that specify the PivotTable ([ISO/IEC29500-1:2012] section 18.10) views and Non-Worksheet PivotTables that are filtered by the Timeline cache (section 2.1.7).

state: A CT_TimelineState element (section 2.6.116) that specifies the information used for display in the Timeline view (section 2.3.5.2).

timelinePivotFilter: A CT_TimelinePivotFilter element (section 2.6.118) that specifies the filter used by the Timeline Cache (section 2.1.7) to filter PivotTable ([ISO/IEC29500-1:2012] section 18.10) views and Non-Worksheet PivotTables. This element MUST exist only if the filterType attribute of the CT_TimelineState (section 2.6.116) element of the Timeline Cache has a value that is not one of the following:

Enumeration Value	Description
dateBetween (Date Between)	Indicates the "between" filter for date values.
dateEqual (Date Equals)	Indicates the "equals" filter for date values.
unknown	Indicates the absence of a filter for date values.

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2012] section A.2) element that specifies future extensibility for this element.

Attributes:

name: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the name of the Timeline cache (section 2.3.5.1). MUST adhere to the name production rule provided in section 2.2.2. MUST be a unique case-insensitive name within the scope of defined names.

xr10:uid: An ST_Guid ([ISO/IEC29500-1:2012] section 22.9.2.4) attribute that specifies the unique id of the Timeline cache (section 2.3.5.1). If any instance of this type specifies this attribute, then all instances MUST specify it, and the values must be distinct

sourceName: An ST_Xstring attribute that specifies the MDX unique name of the key attribute of the associated OLAP hierarchy if the Timeline source data (section 2.3.5.1.1) is an OLAP data source.

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

2036

2037

2038

2039

2040

2041

2042

2043

2044

2045

2046

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

2046.1.1CT_TimelineCachePivotTables

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

Referenced by: CT_TimelineCacheDefinition

A complex type that specifies a group of CT_TimelineCachePivotTable elements that specify the PivotTable ([ISO/IEC29500-1:2012] section 18.10) views and Charts ([ISO/IEC29500-1:2012] section 21.2) based on Non-Worksheet PivotTables that are filtered by the Timeline cache.

Child Elements:

pivotTable: A CT_TimelineCachePivotTable element that specifies the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view or a Non-Worksheet PivotTable that is filtered. The list of pivotTable child elements MUST NOT contain duplicates.

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

2047

2048

2049

2050

2051

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

2051.1.1CT_TimelineCachePivotTable

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

Referenced by: CT_TimelineCachePivotTables

A complex type that specifies a PivotTable ([ISO/IEC29500-1:2012] section 18.10) view filtered by a Timeline cache.

Attributes:

tabId: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the unique identifier (UID) of the worksheet that contains the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view specified by the name attribute. MUST match the sheetId of an existing sheet ([ISO/IEC29500-4:2012] section A.2) element within the workbook. MUST be equal to the decimal equivalent of 0xFFFFFFFF if the PivotTable specified by the name attribute is a Non-Worksheet PivotTable.

name: An ST_Xstring ([ISO/IEC29500-1:2012] section 22.9.2.19) attribute that specifies the name of the PivotTable ([ISO/IEC29500-1:2012] section 18.10) view on the worksheet specified by tabId. MUST match the name attribute of an existing pivotTableDefinition element in the worksheet. The createdVersion attribute of the CT_PivotTableDefinition ([ISO/IEC29500-4:2012] section A.2) element that defines the specified PivotTable ([ISO/IEC29500-1:2012] section 18.10) MUST be greater than or equal to 3.

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

2052

2053

2054

2055

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