[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format



Yüklə 3,69 Mb.
səhifə22/33
tarix12.08.2018
ölçüsü3,69 Mb.
#70004
1   ...   18   19   20   21   22   23   24   25   ...   33

CT_CacheHierarchy is a complex type which specifies additional properties for an OLAP measure.

Attributes:

aggregatedColumn: An int attribute that specifies the zero-based index of PivotTable cache hierarchy which corresponds to this OLAP measure. The referenced CT_CacheHierarchy ([ISO/IEC29500-4:2011] section A.2) element specifies the PivotTable cache hierarchy that this OLAP measure aggregates. MUST only be specified if the measure attribute of this cache hierarchy is "true". The value MUST match the index of an existing cache hierarchy in CT_CacheHierarchies ([ISO/IEC29500-4:2011]) collection or be equal -1 if this OLAP measure is not an implicit measure which aggregates a cache hierarchy.

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







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

2.6.103 CT_SlicerCacheHideNoData

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

Referenced by: slicerCacheHideItemsWithNoData

A complex type that specifies the extended properties of a slicer cache, as specified in section 2.3.2.1.



Child Elements:

slicerCacheOlapLevelName: A CT_SlicerCacheOlapLevelName element that specifies the properties of an OLAP level in the OLAP hierarchy specified by the ancestor slicer cache. slicer items with no data in this OLAP level are not displayed.

Attributes:

count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the number of slicerCacheOlapLevelName child elements of this element.

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













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

2.6.104 CT_SlicerCacheOlapLevelName

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

Referenced by: CT_SlicerCacheHideNoData

A complex type that specifies the properties of an OLAP level in the OLAP hierarchy specified by the ancestor slicer cache. slicer items with no data in this OLAP level are not displayed.



Attributes:

uniqueName: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the MDX unique name of the OLAP level specified by this element within the OLAP hierarchy specified with this slicer cache. The length of this string MUST be at least 1 character and MUST NOT exceed 32,767 characters.

count: An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the total number of hidden slicer items in this OLAP level within the OLAP hierarchy specified by this slicer cache.

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









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

2.6.105 CT_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.













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

2.6.106 CT_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:2011] 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:2011] 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.











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

2.6.107 CT_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:2011] 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:2011] section 12.3.20. This string MUST match the name attribute of a CT_TableStyle element, as specified in [ISO/IEC29500-4:2011] 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.













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

2.6.108 CT_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:2011] 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:2011] 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:2011] 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.









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

2.6.109 CT_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:2011] 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:2011] 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.







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

2.6.110 CT_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.











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

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:2011] section A.2, that specifies future extensibility for this element.

Attributes:

name: An ST_Xstring attribute, as specified in [ISO/IEC29500-1:2011] 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.

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:2011] section 22.9.2.19) that specifies the Timeline style (section 2.3.5.4) of the Timeline view. If this field (1) 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.































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

2.6.112 CT_TimelineCacheDefinition

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

Referenced by: timelineCacheDefinition

A complex type that specifies a Timeline cache.



Child Elements:

pivotTables: A CT_TimelineCachePivotTables element (section 2.6.113) that specifies a group of CT_ TimelineCachePivotTable elements (section 2.6.114) that specify the PivotTable ([ISO/IEC29500-1:2011] section 18.10) views and Non-Worksheet PivotTables that are filtered by the Timeline cache (section 2.1.7).

state: A CT_TimelineState element (section 2.6.116) that specifies the information used for display in the Timeline view (section 2.3.5.2).

timelinePivotFilter: A CT_TimelinePivotFilter element (section 2.6.118) that specifies the filter used by the Timeline Cache (section 2.1.7) to filter PivotTable ([ISO/IEC29500-1:2011] section 18.10) views and Non-Worksheet PivotTables. This element MUST exist only if the filterType attribute of the CT_TimelineState (section 2.6.116) element of the Timeline Cache has a value that is not one of the following:

Enumeration Value

Description

dateBetween (Date Between)

Indicates the "between" filter for date values.

dateEqual (Date Equals)

Indicates the "equals" filter for date values.

unknown

Indicates the absence of a filter for date values.

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

Attributes:

name: An ST_Xstring ([ISO/IEC29500-1:2011] section 22.9.2.19) attribute that specifies the name of the Timeline cache (section 2.3.5.1). MUST adhere to the name production rule provided in section 2.2.2. MUST be a unique case-insensitive name within the scope of defined names.

Yüklə 3,69 Mb.

Dostları ilə paylaş:
1   ...   18   19   20   21   22   23   24   25   ...   33




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