Share via

2.3.36 CT_Slicer

  • Article

Referenced by: CT_Slicers

A workbook slicer.

Attributes:

Name: The name of the slicer.

Caption: The caption of the slicer.

SlicerCacheId: An identifier that the protocol server uses in combination with SlicerViewId to identify a slicer. The combination of the SlicerCacheId and SlicerViewId attributes MUST be unique in the workbook.

SlicerViewId: An identifier that the protocol server uses in combination with SlicerCacheId to identify a slicer. The combination of the SlicerCacheId and SlicerViewId attributes MUST be unique in the workbook.

ExternalSourceIndex: An identifier that the protocol server uses to identify connected data.

Version: A unique identifier for the state of the slicer on the protocol server.

Width: The width of the slicer in points.

Height: The height of the slicer in points.

ZOrder: The z-order for the slicer.

XOriginDelta: The x-coordinate, in points, of the offset of the origin of the slicer from the starting column (2) of the requested range. If the x-coordinate of the origin of the slicer is less than the x-coordinate of the requested range, this value MUST be negative.

YOriginDelta: The y-coordinate, in points, of the offset of the origin of the slicer from the starting row of the requested range. If the y-coordinate of the origin of the slicer is less than the y-coordinate of the requested range, this value MUST be negative.

ClippedWidth: The width, in points, of the portion of the slicer that intersects with the requested range.

ClippedHeight: The height, in points, of the portion of the slicer that intersects the requested range.

Visible: Specifies whether the slicer is visible. The value MUST be true if the slicer is visible and false if it is not visible.

HasConnection: Specifies whether the slicer has an active connection to a PivotTable. This attribute MUST be present and set to true if one of the following conditions is met:

Otherwise, this attribute MUST NOT be present.

IsTimeline: Specifies whether the slicer is time slicer. This attribute Must be present and set to true if the slicer is time slicer. Otherwise, this attribute MUST NOT be present.

SlicerCaptionHeight: The height, in points, of the caption of the slicer.

SlicerFullHeight: The height, in points, of the slicer when all the items in the slicer are visible.

ItemCount: Total number of items in the slicer. MUST be non-negative.

CanExpand: Specifies whether slicer can be expanded when in named object view mode. MUST be true if ItemCount is greater than zero and the slicer has filtering applied. Otherwise MUST be false.

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

 <xs:complexType name="CT_Slicer">
   <xs:sequence/>
   <xs:attribute name="Name" type="ST_nonEmptyString" use="required"/>
   <xs:attribute name="Caption" type="xs:string" use="required"/>
   <xs:attribute name="SlicerCacheId" type="xs:int" use="required"/>
   <xs:attribute name="SlicerViewId" type="xs:int" use="required"/>
   <xs:attribute name="ExternalSourceIndex" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="Version" type="xs:int" use="required"/>
   <xs:attribute name="Width" type="ST_nonNegativeDouble" use="required"/>
   <xs:attribute name="Height" type="ST_nonNegativeDouble" use="required"/>
   <xs:attribute name="ZOrder" type="xs:int" use="required"/>
   <xs:attribute name="XOriginDelta" type="xs:double" default="0" use="optional"/>
   <xs:attribute name="YOriginDelta" type="xs:double" default="0" use="optional"/>
   <xs:attribute name="ClippedWidth" type="ST_nonNegativeDouble" default="0" use="optional"/>
   <xs:attribute name="ClippedHeight" type="ST_nonNegativeDouble" default="0" use="optional"/>
   <xs:attribute name="Visible" type="xs:boolean" default="true" use="optional"/>
   <xs:attribute name="HasConnection" type="xs:boolean" default="true" use="optional"/>
   <xs:attribute name="IsTimeline" type="xs:boolean" default="false" use="optional"/>
   <xs:attribute name="SlicerCaptionHeight" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="SlicerFullHeight" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="ItemCount" type="xs:int" default="0" use="optional"/>
   <xs:attribute name="CanExpand" type="xs:boolean" default="false" use="optional"/>
 </xs:complexType>

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