2013.1.1CT_Timelines
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main
Referenced by: timelines
A complex type that specifies a list of CT_Timeline elements, as specified in section 2.6.111. The list of CT_Timeline elements specifies all Timeline views on the worksheet.
Child Elements:
timeline: A CT_Timeline element that specifies a Timeline view on the worksheet.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.
2014
2015
2016
2017
2018
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2018.1.1CT_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:2012] section A.2, that specifies future extensibility for this element.
Attributes:
name: An ST_Xstring attribute, as specified in [ISO/IEC29500-1:2012] 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:2012] 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] 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:2012] 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:
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.
2019
2020
2021
2022
2023
2024
2025
2026
2027
2028
2029
2030
2031
2032
2033
2034
2035
See section 5.3 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
Dostları ilə paylaş: |