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

1968.1.1CT_TimelineRefs

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

Referenced by: timelineRefs

CT_TimelineRefs is a complex type that specifies a list of Timeline (section 2.3.5) part identifiers for the worksheet. MUST contain exactly one Timeline part identifier.

Child Elements:

timelineRef: A CT_TimelineRef element (section 2.6.101) that specifies the Timeline (section 2.3.5) part identifier for the worksheet.

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

1969

1970

1971

1972

1973

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

1973.1.1CT_TimelineRef

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

Referenced by: CT_TimelineRefs

A complex type that specifies a relationship identifier of the part that contains the Timelines in this worksheet.

Attributes:

r:id: An ST_RelationshipId ([ISO/IEC29500-1:2012] section 22.8.2.1) attribute that specifies a relationship identifier of the part that contains the Timelines in this worksheet.

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

1974

1975

1976

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

1976.1.1CT_CacheHierarchy

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

Referenced by: cacheHierarchy

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:2012] 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:2012]) 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.

1977

1978

1979

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

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

1980

1981

1982

1983

1984

1985

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

1985.1.1CT_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:2012] 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.

1986

1987

1988

1989

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