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

showHeader: A Boolean attribute, as specified in [XMLSCHEMA2] section 3.2.2, that specifies whether the header is displayed.

Value	Meaning
"true"	The header is displayed.
"false"	The header is suppressed.

showSelectionLabel: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the selection label is displayed.

Value	Meaning
"true"	The selection label is displayed.
"false"	The selection label is suppressed.

showTimeLevel: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the time level is displayed.

Value	Meaning
"true"	The time level is displayed.
"false"	The time level is suppressed.

showHorizontalScrollbar: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the horizontal scrollbar is displayed.

Value	Meaning
"true"	The horizontal scrollbar is displayed.
"false"	The horizontal scrollbar is suppressed.

level: An unsignedInt attribute, as specified in [XMLSCHEMA2] section 3.3.22, that specifies the current time level of the Timeline (section 2.3.5). This element MUST be a value from the following table:

Value	Meaning
0	Year
1	Quarter
2	Month
3	Day

selectionLevel: An unsignedInt attribute that specifies the time level at which the current selection was made for the Timeline. This element MUST be a value from the following table:

Value	Meaning
0	Year
1	Quarter
2	Month
3	Day

scrollPosition: A dateTime attribute ([XMLSCHEMA2] section 3.2.7) that specifies the start date of the timespan scrolling position of the Timeline.

style: An ST_Xstring attribute ([ISO/IEC29500-1:2011] section 22.9.2.19) that specifies the Timeline style (section 2.3.5.4) of the Timeline view. If this field (1) exists, this string MUST match the name attribute of a CT_TimelineStyle element (section 2.6.107) within this workbook or MUST be equal to one of the built-in Timeline style names:

Built-in Timeline style names
TimelineStyleLight1
TimelineStyleLight2
TimelineStyleLight3
TimelineStyleLight4
TimelineStyleLight5
TimelineStyleLight6
TimelineStyleDark1
TimelineStyleDark2
TimelineStyleDark3
TimelineStyleDark4
TimelineStyleDark5
TimelineStyleDark6

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

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

2.6.112 CT_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:2011] 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:2011] 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:2011] section A.2) element that specifies future extensibility for this element.

Attributes:

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

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

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

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

2.6.113 CT_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:2011] section 18.10) views and Charts ([ISO/IEC29500-1:2011] 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:2011] 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.

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

2.6.114 CT_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:2011] 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:2011] section 18.10) view specified by the name attribute. MUST match the sheetId of an existing sheet (1) ([ISO/IEC29500-4:2011] 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:2011] section 22.9.2.19) attribute that specifies the name of the PivotTable ([ISO/IEC29500-1:2011] 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:2011] section A.2) element that defines the specified PivotTable ([ISO/IEC29500-1:2011] 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.

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

2.6.115 CT_TimelineRange

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

Referenced by: CT_TimelineState

A complex type that specifies the date range for a CT_TimelineState element that is the parent of this element.

Attributes:

startDate: A dateTime ([XMLSCHEMA2] section 3.2.7) attribute that specifies the start value of the date range.

endDate: A dateTime attribute that specifies the end value of the date range.

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

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

2.6.116 CT_TimelineState

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

Referenced by: CT_TimelineCacheDefinition

The CT_TimelineState complex type specifies the Timeline state (section 2.3.5.1.4) of the Timeline cache (section 2.3.5.1).

Child Elements: