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



Yüklə 5,13 Mb.
səhifə59/71
tarix09.01.2019
ölçüsü5,13 Mb.
#94307
1   ...   55   56   57   58   59   60   61   62   ...   71

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).



Yüklə 5,13 Mb.

Dostları ilə paylaş:
1   ...   55   56   57   58   59   60   61   62   ...   71




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2024
rəhbərliyinə müraciət

gir | qeydiyyatdan keç
    Ana səhifə


yükləyin