[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format
Yüklə 3,69 Mb.
|
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
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
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
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
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
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
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
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
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
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.
showSelectionLabel: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the selection label is displayed.
showTimeLevel: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the time level is displayed.
showHorizontalScrollbar: A Boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether the horizontal scrollbar is displayed.
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:
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:
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:
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
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:
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ş:
|