Compartilhar via


OlapSlicerCacheRange Class

Defines the OlapSlicerCacheRange Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is x14:range.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlCompositeElement
      DocumentFormat.OpenXml.Office2010.Excel.OlapSlicerCacheRange

Namespace:  DocumentFormat.OpenXml.Office2010.Excel
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
<ChildElementInfoAttribute(GetType(OlapSlicerCacheItem), FileFormatVersions.Office2010)> _
Public Class OlapSlicerCacheRange _
    Inherits OpenXmlCompositeElement
'Usage
Dim instance As OlapSlicerCacheRange
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
[ChildElementInfoAttribute(typeof(OlapSlicerCacheItem), FileFormatVersions.Office2010)]
public class OlapSlicerCacheRange : OpenXmlCompositeElement

Remarks

The following table lists the possible child types:

  • OlapSlicerCacheItem <x14:i>

2.6.70 CT_OlapSlicerCacheRange

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

Referenced by: CT_OlapSlicerCacheRanges

A complex type that specifies a collection of cached OLAP slicer items in the OLAP level specified by the ancestor CT_OlapSlicerCacheLevelData element.

Child Elements:

i : A CT_OlapSlicerCacheItem element that specifies an OLAP slicer item in the OLAP level specified by the CT_OlapSlicerCacheLevelData element that is part of this range. The number of CT_OlapSlicerCacheItem child elements MUST be greater than 0 and equal to or less than 1000.

Attributes:

startItem : An unsignedInt ([XMLSCHEMA2] section 3.3.22) attribute that specifies the zero-based index of the OLAP member on this OLAP level for the first item in this range. The order of the OLAP slicer item is determined by the current sort order and current slicer cross filtering setting applied to all OLAP slicer items on this OLAP level. The value of the starting position MUST be 0 or MUST be a multiple of 1000. See Slicer Items for more information.

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

<xsd:complexType name="CT_OlapSlicerCacheRange">

<xsd:sequence>

<xsd:element name="i" type="CT_OlapSlicerCacheItem" minOccurs="1" maxOccurs="unbounded"/>

</xsd:sequence>

<xsd:attribute name="startItem" type="xsd:unsignedInt" use="required"/>

</xsd:complexType>

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

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

OlapSlicerCacheRange Members

DocumentFormat.OpenXml.Office2010.Excel Namespace