2.6.111 CT_Timeline

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

Referenced by: CT_Timelines

The CT_Timeline complex type specifies a Timeline view (section 2.3.5.2) in this worksheet.

Child Elements:

extLst:  A CT_ExtensionList element, as specified in [ISO/IEC29500-4:2016] section A.2, that specifies future extensibility for this element.

Attributes:

name: An ST_Xstring attribute, as specified in [ISO/IEC29500-1:2016] section 22.9.2.19, that specifies the name of the Timeline view. This element MUST be a unique case-insensitive name within the scope of this workbook. The length of this attribute MUST be greater than or equal to one character and MUST be less than or equal to 32767 characters.

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

cache: An ST_Xstring attribute that specifies the name of the Timeline cache (section 2.3.5.1) that this Timeline view is associated with. There MUST be a CT_TimelineCacheDefinition element (section 2.6.112) within this workbook with the name attribute equal to the value of this attribute.

caption: An ST_Xstring attribute that specifies the caption of the Timeline view. If this string exists, the length MUST be greater than or equal to one character.

showHeader: A Boolean attribute, as specified in [XMLSCHEMA2/2] 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/2] 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/2] 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/2] 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/2] 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:

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:

scrollPosition: A dateTime attribute ([XMLSCHEMA2/2] 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:2016] section 22.9.2.19) that specifies the Timeline style (section 2.3.5.4) of the Timeline view. If this field 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:

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

 <xsd:complexType name="CT_Timeline">
   <xsd:sequence>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="name" type="x:ST_Xstring" use="required"/>
   <xsd:attribute ref="xr10:uid" use="optional"/>
   <xsd:attribute name="cache" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="caption" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="showHeader" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="showSelectionLabel" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="showTimeLevel" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="showHorizontalScrollbar" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="level" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="selectionLevel" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="scrollPosition" type="xsd:dateTime" use="optional"/>
   <xsd:attribute name="style" type="x:ST_Xstring" use="optional"/>
 </xsd:complexType>

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