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

1989.1.1CT_TimelineStyles

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

Referenced by: timelineStyles

A complex type that specifies a group of Timeline Styles and the default Timeline Style to apply to Timelines.

Child Elements:

timelineStyle: A CT_TimelineStyle element that specifies a Timeline Style.

Attributes:

defaultTimelineStyle: A string ([XMLSCHEMA2] section 3.2.1) attribute that specifies the name of the default Timeline Style to apply to Timelines. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters.

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

1990

1991

1992

1993

1994

1995

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

1995.1.1CT_TimelineStyleElements

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

Referenced by: CT_TimelineStyle

A complex type that specifies the list of table style ([ISO/IEC29500-1:2012] section 18.8) elements of a Timeline Style that are specific to Timelines.

Child Elements:

timelineStyleElement: A CT_TimelineStyleElement element that specifies a table style ([ISO/IEC29500-1:2012] section 18.8) element of a timeline style that is specific to timelines.

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

1996

1997

1998

1999

2000

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

2000.1.1CT_TimelineStyle

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

Referenced by: CT_TimelineStyles

CT_TimelineStyle specifies table style elements, as specified in [ISO/IEC29500-1:2012] section 18.8, of the timeline style, as specified in section Timeline Styles, that are specific to timelines, as specified in section Timelines.

Child Elements:

timelineStyleElements: A CT_TimelineStyleElements, as specified in section Timeline Style Elements, that specifies table style elements of the timeline style that are specific to timelines. There MUST NOT be more than one CT_TimelineStyleElements in this element.

Attributes:

name: A string attribute, as specified in [XMLSCHEMA2] section 3.2.1, that specifies the name of the user-defined table style that this timeline style is based upon. The length of the string MUST be greater than or equal to 1 character and less than or equal to 255 characters. This string MUST be unique within the CT_TimelineStyle elements in the Styles part, as specified in [ISO/IEC29500-1:2012] section 12.3.20. This string MUST match the name attribute of a CT_TableStyle element, as specified in [ISO/IEC29500-4:2012] section A.2, in the Styles part. In the CT_TableStyle element with a name attribute that matches this string, the pivot attribute MUST equal "false" and the table attribute MUST equal "false".

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

2001

2002

2003

2004

2005

2006

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

2006.1.1CT_TimelineStyleElement

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

Referenced by: CT_TimelineStyleElements

A complex type that specifies a table style element, as specified in [ISO/IEC29500-1:2012] section 18.8, of a timeline style, as specified in section Timeline Styles.

Attributes:

type: An ST_TimelineStyleType attribute that specifies the type of the table style element. This attribute MUST be unique within the parent CT_TimelineStyleElements complex type.

dxfId: An ST_DxfId attribute, as specified in [ISO/IEC29500-1:2012] section 18.18.25, that specifies a zero-based index for the list of elements specified by the dxfs global element, as specified in section 2.4.55. The specified CT_Dxf complex type, as specified in [ISO/IEC29500-4:2012] section A.2, specifies the formatting to use with this table style element.

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

2007

2008

2009

2010

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

2010.1.1CT_TimelinePivotCacheDefinition

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

Referenced by: timelinePivotCacheDefinition

A complex type that specifies the extended properties of a PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache definition.

Attributes:

timelineData: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the Timeline Cache Relationship to PivotCache. MUST be "true" if the OLAP PivotTable ([ISO/IEC29500-1:2012] section 18.10) PivotCache definition is being referenced by a timeline cache.

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

2011

2012

2013

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