2.2.4.42 SlicerView

  • Article

Namespace: http://schemas.microsoft.com/office/Excel/Server/WebServices/ExcelServerInternalService/

Specifies slicer attributes such as display properties specific to the slicer and attributes describing the slicer items.

 <xs:complexType name="SlicerView" xmlns:xs="http://www.w3.org/2001/XMLSchema">
   <xs:sequence>
     <xs:element minOccurs="1" maxOccurs="1" name="Version" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="RequiresUpdate" type="xs:boolean"/>
     <xs:element minOccurs="1" maxOccurs="1" name="HasEffectiveSelection" type="xs:boolean"/>
     <xs:element minOccurs="1" maxOccurs="1" name="ItemsToScrollBar" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="CellDistance" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="CellMargin" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="ItemCount" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Offset" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Margin" type="xs:unsignedInt"/>
     <xs:element minOccurs="1" maxOccurs="1" name="ItemWidth" type="xs:unsignedInt"/>
     <xs:element minOccurs="1" maxOccurs="1" name="ItemHeight" type="xs:unsignedInt"/>
     <xs:element minOccurs="1" maxOccurs="1" name="CaptionHeight" type="xs:unsignedInt"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Width" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="Height" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="ColCount" type="xs:int"/>
     <xs:element minOccurs="1" maxOccurs="1" name="RowCount" type="xs:int"/>
     <xs:element minOccurs="0" maxOccurs="1" name="Name" type="xs:string"/>
     <xs:element minOccurs="0" maxOccurs="1" name="Caption" type="xs:string"/>
     <xs:element minOccurs="1" maxOccurs="1" name="ScrollbarVisible" type="xs:boolean"/>
     <xs:element minOccurs="1" maxOccurs="1" name="CaptionVisible" type="xs:boolean"/>
     <xs:element minOccurs="1" maxOccurs="1" name="OlapSourced" type="xs:boolean"/>
   </xs:sequence>
 </xs:complexType>

Version: Specifies the version of the slicer only if the protocol client requests a specific version of that slicer. MUST be -1 in all other cases.

RequiresUpdate: MUST be true if the slicer items are out of date. MUST be false otherwise.

HasEffectiveSelection: MUST be true if the slicer has effective selection. MUST be false otherwise.

ItemsToScrollBar: Distance in pixels from the slicer items to the vertical scrollbar. MUST be equal to or greater than 0.

CellDistance: Distance in pixels between slicer items. MUST be equal to or greater than 0.

CellMargin: Horizontal margin for slicer items in pixels. MUST be equal to or greater than 0.

ItemCount: Number of known slicer items in the slicer. MUST be equal to or greater than 0.

Offset: Index of the first visible slicer item. MUST be equal to or greater than 0.

Margin: External margin for the slicer in pixels. MUST be equal to or greater than 0.

ItemWidth: Width in pixels of each slicer item. MUST be equal to or greater than 0.

ItemHeight: Height in pixels for each slicer item. MUST be equal to or greater than 0.

CaptionHeight: Height in pixels for the slicer header. MUST be equal to or greater than 0.

Width: Slicer width in pixels. MUST be equal to or greater than 0.

Height: Slicer height in pixels. MUST be equal to or greater than 0.

ColCount: Number of slicer item columns (2). If ItemCount is greater than 0, then ColCount MUST be greater than 0. ColCount MUST be ignored if ItemCount is 0.

RowCount: Number of visible slicer item rows (2). If ItemCount is greater than 0, then RowCount MUST be greater than 0. RowCount MUST be ignored if ItemCount is 0.

Name: The name of the slicer.

Caption: The caption of the slicer.

ScrollbarVisible: MUST be true if the scrollbar is not visible. MUST be false otherwise.

CaptionVisible: MUST be true if the caption is not visible. MUST be false otherwise.

OlapSourced: MUST be true if the data source for the slicer is Online Analytical Processing (OLAP). MUST be false otherwise.