Share via

2.6.116 CT_TimelineState

  • Article

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:

selection: A CT_TimelineRange element (section 2.6.115) that specifies the start and end dates that are selected in the Timeline view (section 2.3.5.2). The start and end dates in the selection element MUST be interpreted as dateTime values ([XMLSCHEMA2/2] section 3.2.7).

bounds: A CT_TimelineRange element that specifies the minimum and maximum dates available for display in the Timeline view. The minimum and maximum dates in the bounds element MUST be interpreted as dateTime values ([XMLSCHEMA2/2] section 3.2.7).

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

Attributes:

singleRangeFilterState: A Boolean attribute ([XMLSCHEMA2/2] section 3.2.2) that specifies whether the filtering state of the Timeline (section 2.3.5) is a contiguous date range.

Value

Meaning

"true"

The filtering state of the Timeline is a contiguous date range.

"false"

The filtering state of the Timeline is not a contiguous date range.

minimalRefreshVersion: An unsignedInt attribute ([XMLSCHEMA2/2] section 3.3.22) that specifies the minimum application version required to refresh the Timeline cache.

lastRefreshVersion: An unsignedInt attribute that specifies the application version that last refreshed the Timeline cache.

pivotCacheId: An unsignedInt attribute that specifies the associated OLAP PivotTable ([ISO/IEC29500-1:2016] section 18.10) PivotCache. This element MUST be equal to the pivotCacheId attribute of an existing CT_PivotCacheDefinition element (section 2.6.33).

filterType: An ST_PivotFilterType attribute ([ISO/IEC29500-1:2016] section 18.18.59) that specifies type of the filter ([ISO/IEC29500-1:2016] section 18.10.1.33) used in the Timeline.

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

 <xsd:complexType name="CT_TimelineState">
   <xsd:sequence>
     <xsd:element name="selection" type="CT_TimelineRange" minOccurs="0" maxOccurs="1"/>
     <xsd:element name="bounds" type="CT_TimelineRange" minOccurs="1" maxOccurs="1"/>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="singleRangeFilterState" type="xsd:boolean" use="optional" default="true"/>
   <xsd:attribute name="minimalRefreshVersion" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="lastRefreshVersion" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="pivotCacheId" type="xsd:unsignedInt" use="required"/>
   <xsd:attribute name="filterType" use="required" type="x:ST_PivotFilterType"/>
 </xsd:complexType>

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