Slicer

Slicer class

summary description of Slicer View

class Slicer;

Properties

Property	Type	Description
sortOrderType	SortOrder	Indicates the type of sorting items.
showMissing	boolean	Indicates whether to show items deteleted from the data source.
showTypeOfItemsWithNoData	ItemsWithNoDataShowMode	Indicates whether to show items deteleted from the data source.
showAllItems	boolean	Indicates whether to show all items even if there are no data or they are deleted. Default value is true;
title	string	Specifies the title of the current Slicer object.
alternativeText	string	Returns or sets the descriptive (alternative) text string of the Slicer object.
isPrintable	boolean	Indicates whether the slicer object is printable.
isLocked	boolean	Indicates whether the slicer shape is locked.
placement	PlacementType	Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
lockedAspectRatio	boolean	Indicates whether locking aspect ratio.
lockedPosition	boolean	Indicates whether the specified slicer can be moved or resized by using the user interface.
shape	SlicerShape	Readonly. Returns the Shape object associated with the specified slicer. Read-only.
slicerCache	SlicerCache	Readonly. Returns the SlicerCache object associated with the slicer. Read-only.
parent	Worksheet	Readonly. Returns the Worksheet object which contains this slicer. Read-only.
worksheet	Worksheet	Readonly. Returns the Worksheet object which contains this slicer. Read-only.
styleType	SlicerStyleType	Specify the type of Built-in slicer style. The default type is SlicerStyleLight1.
name	string	Returns or sets the name of the specified slicer
caption	string	Returns or sets the caption of the specified slicer.
firstItemIndex	number	Specifies the zero-based index of the first slicer item.
captionVisible	boolean	Returns or sets whether the header that displays the slicer Caption is visible. The default value is true
showCaption	boolean	Indicates whether the header of the slicer is visible. The default value is true
numberOfColumns	number	Returns or sets the number of columns in the specified slicer. The default value is 1.
leftPixel	number	Returns or sets the horizontal offset of slicer shape from its left column, in pixels.
topPixel	number	Returns or sets the vertical offset of slicer shape from its top row, in pixels.
width	number	Returns or sets the width of the specified slicer, in points.
widthPixel	number	Returns or sets the width of the specified slicer, in pixels.
height	number	Returns or sets the height of the specified slicer, in points.
heightPixel	number	Returns or sets the height of the specified slicer, in pixels.
columnWidthPixel	number	Gets or sets the width of each column in the slicer, in unit of pixels.
columnWidth	number	Returns or sets the width of each column in the slicer in unit of points.
rowHeightPixel	number	Returns or sets the height of each row in the specified slicer, in unit of pixels.
rowHeight	number	Returns or sets the height of each row in the specified slicer in unit of points.

Methods

Method	Description
getSortOrderType()	@deprecated. Please use the ‘sortOrderType’ property instead. Indicates the type of sorting items.
setSortOrderType(SortOrder)	@deprecated. Please use the ‘sortOrderType’ property instead. Indicates the type of sorting items.
getShowMissing()	@deprecated. Please use the ‘showMissing’ property instead. Indicates whether to show items deteleted from the data source.
setShowMissing(boolean)	@deprecated. Please use the ‘showMissing’ property instead. Indicates whether to show items deteleted from the data source.
getShowTypeOfItemsWithNoData()	@deprecated. Please use the ‘showTypeOfItemsWithNoData’ property instead. Indicates whether to show items deteleted from the data source.
setShowTypeOfItemsWithNoData(ItemsWithNoDataShowMode)	@deprecated. Please use the ‘showTypeOfItemsWithNoData’ property instead. Indicates whether to show items deteleted from the data source.
getShowAllItems()	@deprecated. Please use the ‘showAllItems’ property instead. Indicates whether to show all items even if there are no data or they are deleted. Default value is true;
setShowAllItems(boolean)	@deprecated. Please use the ‘showAllItems’ property instead. Indicates whether to show all items even if there are no data or they are deleted. Default value is true;
getTitle()	@deprecated. Please use the ’title’ property instead. Specifies the title of the current Slicer object.
setTitle(string)	@deprecated. Please use the ’title’ property instead. Specifies the title of the current Slicer object.
getAlternativeText()	@deprecated. Please use the ‘alternativeText’ property instead. Returns or sets the descriptive (alternative) text string of the Slicer object.
setAlternativeText(string)	@deprecated. Please use the ‘alternativeText’ property instead. Returns or sets the descriptive (alternative) text string of the Slicer object.
isPrintable()	@deprecated. Please use the ‘isPrintable’ property instead. Indicates whether the slicer object is printable.
setIsPrintable(boolean)	@deprecated. Please use the ‘isPrintable’ property instead. Indicates whether the slicer object is printable.
isLocked()	@deprecated. Please use the ‘isLocked’ property instead. Indicates whether the slicer shape is locked.
setIsLocked(boolean)	@deprecated. Please use the ‘isLocked’ property instead. Indicates whether the slicer shape is locked.
getPlacement()	@deprecated. Please use the ‘placement’ property instead. Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
setPlacement(PlacementType)	@deprecated. Please use the ‘placement’ property instead. Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
getLockedAspectRatio()	@deprecated. Please use the ’lockedAspectRatio’ property instead. Indicates whether locking aspect ratio.
setLockedAspectRatio(boolean)	@deprecated. Please use the ’lockedAspectRatio’ property instead. Indicates whether locking aspect ratio.
getLockedPosition()	@deprecated. Please use the ’lockedPosition’ property instead. Indicates whether the specified slicer can be moved or resized by using the user interface.
setLockedPosition(boolean)	@deprecated. Please use the ’lockedPosition’ property instead. Indicates whether the specified slicer can be moved or resized by using the user interface.
getShape()	@deprecated. Please use the ‘shape’ property instead. Returns the Shape object associated with the specified slicer. Read-only.
getSlicerCache()	@deprecated. Please use the ‘slicerCache’ property instead. Returns the SlicerCache object associated with the slicer. Read-only.
getParent()	@deprecated. Please use the ‘parent’ property instead. Returns the Worksheet object which contains this slicer. Read-only.
getWorksheet()	@deprecated. Please use the ‘worksheet’ property instead. Returns the Worksheet object which contains this slicer. Read-only.
getStyleType()	@deprecated. Please use the ‘styleType’ property instead. Specify the type of Built-in slicer style. The default type is SlicerStyleLight1.
setStyleType(SlicerStyleType)	@deprecated. Please use the ‘styleType’ property instead. Specify the type of Built-in slicer style. The default type is SlicerStyleLight1.
getName()	@deprecated. Please use the ’name’ property instead. Returns or sets the name of the specified slicer
setName(string)	@deprecated. Please use the ’name’ property instead. Returns or sets the name of the specified slicer
getCaption()	@deprecated. Please use the ‘caption’ property instead. Returns or sets the caption of the specified slicer.
setCaption(string)	@deprecated. Please use the ‘caption’ property instead. Returns or sets the caption of the specified slicer.
getFirstItemIndex()	@deprecated. Please use the ‘firstItemIndex’ property instead. Specifies the zero-based index of the first slicer item.
setFirstItemIndex(number)	@deprecated. Please use the ‘firstItemIndex’ property instead. Specifies the zero-based index of the first slicer item.
getCaptionVisible()	@deprecated. Please use the ‘captionVisible’ property instead. Returns or sets whether the header that displays the slicer Caption is visible. The default value is true
setCaptionVisible(boolean)	@deprecated. Please use the ‘captionVisible’ property instead. Returns or sets whether the header that displays the slicer Caption is visible. The default value is true
getShowCaption()	@deprecated. Please use the ‘showCaption’ property instead. Indicates whether the header of the slicer is visible. The default value is true
setShowCaption(boolean)	@deprecated. Please use the ‘showCaption’ property instead. Indicates whether the header of the slicer is visible. The default value is true
getNumberOfColumns()	@deprecated. Please use the ’numberOfColumns’ property instead. Returns or sets the number of columns in the specified slicer. The default value is 1.
setNumberOfColumns(number)	@deprecated. Please use the ’numberOfColumns’ property instead. Returns or sets the number of columns in the specified slicer. The default value is 1.
getLeftPixel()	@deprecated. Please use the ’leftPixel’ property instead. Returns or sets the horizontal offset of slicer shape from its left column, in pixels.
setLeftPixel(number)	@deprecated. Please use the ’leftPixel’ property instead. Returns or sets the horizontal offset of slicer shape from its left column, in pixels.
getTopPixel()	@deprecated. Please use the ’topPixel’ property instead. Returns or sets the vertical offset of slicer shape from its top row, in pixels.
setTopPixel(number)	@deprecated. Please use the ’topPixel’ property instead. Returns or sets the vertical offset of slicer shape from its top row, in pixels.
getWidth()	@deprecated. Please use the ‘width’ property instead. Returns or sets the width of the specified slicer, in points.
setWidth(number)	@deprecated. Please use the ‘width’ property instead. Returns or sets the width of the specified slicer, in points.
getWidthPixel()	@deprecated. Please use the ‘widthPixel’ property instead. Returns or sets the width of the specified slicer, in pixels.
setWidthPixel(number)	@deprecated. Please use the ‘widthPixel’ property instead. Returns or sets the width of the specified slicer, in pixels.
getHeight()	@deprecated. Please use the ‘height’ property instead. Returns or sets the height of the specified slicer, in points.
setHeight(number)	@deprecated. Please use the ‘height’ property instead. Returns or sets the height of the specified slicer, in points.
getHeightPixel()	@deprecated. Please use the ‘heightPixel’ property instead. Returns or sets the height of the specified slicer, in pixels.
setHeightPixel(number)	@deprecated. Please use the ‘heightPixel’ property instead. Returns or sets the height of the specified slicer, in pixels.
getColumnWidthPixel()	@deprecated. Please use the ‘columnWidthPixel’ property instead. Gets or sets the width of each column in the slicer, in unit of pixels.
setColumnWidthPixel(number)	@deprecated. Please use the ‘columnWidthPixel’ property instead. Gets or sets the width of each column in the slicer, in unit of pixels.
getColumnWidth()	@deprecated. Please use the ‘columnWidth’ property instead. Returns or sets the width of each column in the slicer in unit of points.
setColumnWidth(number)	@deprecated. Please use the ‘columnWidth’ property instead. Returns or sets the width of each column in the slicer in unit of points.
getRowHeightPixel()	@deprecated. Please use the ‘rowHeightPixel’ property instead. Returns or sets the height of each row in the specified slicer, in unit of pixels.
setRowHeightPixel(number)	@deprecated. Please use the ‘rowHeightPixel’ property instead. Returns or sets the height of each row in the specified slicer, in unit of pixels.
getRowHeight()	@deprecated. Please use the ‘rowHeight’ property instead. Returns or sets the height of each row in the specified slicer in unit of points.
setRowHeight(number)	@deprecated. Please use the ‘rowHeight’ property instead. Returns or sets the height of each row in the specified slicer in unit of points.
addPivotConnection(PivotTable)	Adds PivotTable connection.
removePivotConnection(PivotTable)	Removes PivotTable connection.
refresh()	Refreshing the slicer. Meanwhile, Refreshing and Calculating PivotTables which this slicer based on.
isNull()	Checks whether the implementation object is null.

sortOrderType

Indicates the type of sorting items.

sortOrderType : SortOrder;

showMissing

Indicates whether to show items deteleted from the data source.

showMissing : boolean;

Remarks

Only works when Slicer.ShowAllItems is true.

showTypeOfItemsWithNoData

Indicates whether to show items deteleted from the data source.

showTypeOfItemsWithNoData : ItemsWithNoDataShowMode;

Remarks

Only works when Slicer.ShowAllItems is true.

showAllItems

Indicates whether to show all items even if there are no data or they are deleted. Default value is true;

showAllItems : boolean;

title

Specifies the title of the current Slicer object.

title : string;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Title property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

alternativeText

Returns or sets the descriptive (alternative) text string of the Slicer object.

alternativeText : string;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.AlternativeText property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

isPrintable

Indicates whether the slicer object is printable.

isPrintable : boolean;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.IsPrintable property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

isLocked

Indicates whether the slicer shape is locked.

isLocked : boolean;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.IsLocked property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

placement

Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.

placement : PlacementType;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Placement property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

lockedAspectRatio

Indicates whether locking aspect ratio.

lockedAspectRatio : boolean;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.GetLockedProperty() method. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

lockedPosition

Indicates whether the specified slicer can be moved or resized by using the user interface.

lockedPosition : boolean;

shape

Readonly. Returns the Shape object associated with the specified slicer. Read-only.

shape : SlicerShape;

slicerCache

Readonly. Returns the SlicerCache object associated with the slicer. Read-only.

slicerCache : SlicerCache;

parent

Readonly. Returns the Worksheet object which contains this slicer. Read-only.

parent : Worksheet;

Remarks

NOTE: This member is now obsolete. Instead, please use Slicer.Worksheet property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

worksheet

Readonly. Returns the Worksheet object which contains this slicer. Read-only.

worksheet : Worksheet;

styleType

Specify the type of Built-in slicer style. The default type is SlicerStyleLight1.

styleType : SlicerStyleType;

name

Returns or sets the name of the specified slicer

name : string;

caption

Returns or sets the caption of the specified slicer.

caption : string;

firstItemIndex

Specifies the zero-based index of the first slicer item.

firstItemIndex : number;

captionVisible

Returns or sets whether the header that displays the slicer Caption is visible. The default value is true

captionVisible : boolean;

Remarks

NOTE: This member is now obsolete. Instead, please use Slicer.ShowCaption property. This property will be removed 12 months later since January 2026. Aspose apologizes for any inconvenience you may have experienced.

showCaption

Indicates whether the header of the slicer is visible. The default value is true

showCaption : boolean;

numberOfColumns

Returns or sets the number of columns in the specified slicer. The default value is 1.

numberOfColumns : number;

leftPixel

Returns or sets the horizontal offset of slicer shape from its left column, in pixels.

leftPixel : number;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Left property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

topPixel

Returns or sets the vertical offset of slicer shape from its top row, in pixels.

topPixel : number;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Top property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

width

Returns or sets the width of the specified slicer, in points.

width : number;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.WidthPt property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

widthPixel

Returns or sets the width of the specified slicer, in pixels.

widthPixel : number;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Width property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

height

Returns or sets the height of the specified slicer, in points.

height : number;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.HeightPt property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

heightPixel

Returns or sets the height of the specified slicer, in pixels.

heightPixel : number;

Remarks

NOTE: This member is now obsolete. Instead, please use Shape.Height property. This property will be removed 12 months later since May 2025. Aspose apologizes for any inconvenience you may have experienced.

columnWidthPixel

Gets or sets the width of each column in the slicer, in unit of pixels.

columnWidthPixel : number;

columnWidth

Returns or sets the width of each column in the slicer in unit of points.

columnWidth : number;

rowHeightPixel

Returns or sets the height of each row in the specified slicer, in unit of pixels.

rowHeightPixel : number;

rowHeight

Returns or sets the height of each row in the specified slicer in unit of points.

rowHeight : number;

getSortOrderType()

@deprecated. Please use the ‘sortOrderType’ property instead. Indicates the type of sorting items.

getSortOrderType() : SortOrder;

Returns

SortOrder

setSortOrderType(SortOrder)

@deprecated. Please use the ‘sortOrderType’ property instead. Indicates the type of sorting items.

setSortOrderType(value: SortOrder) : void;

Parameters:

Parameter	Type	Description
value	SortOrder	The value to set.

getShowMissing()

@deprecated. Please use the ‘showMissing’ property instead. Indicates whether to show items deteleted from the data source.

getShowMissing() : boolean;

Remarks

Only works when Slicer.ShowAllItems is true.

setShowMissing(boolean)

@deprecated. Please use the ‘showMissing’ property instead. Indicates whether to show items deteleted from the data source.

setShowMissing(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Remarks

Only works when Slicer.ShowAllItems is true.

getShowTypeOfItemsWithNoData()

@deprecated. Please use the ‘showTypeOfItemsWithNoData’ property instead. Indicates whether to show items deteleted from the data source.

getShowTypeOfItemsWithNoData() : ItemsWithNoDataShowMode;

Returns

ItemsWithNoDataShowMode

Remarks

Only works when Slicer.ShowAllItems is true.

setShowTypeOfItemsWithNoData(ItemsWithNoDataShowMode)

@deprecated. Please use the ‘showTypeOfItemsWithNoData’ property instead. Indicates whether to show items deteleted from the data source.

setShowTypeOfItemsWithNoData(value: ItemsWithNoDataShowMode) : void;

Parameters:

Parameter	Type	Description
value	ItemsWithNoDataShowMode	The value to set.

Remarks

Only works when Slicer.ShowAllItems is true.

getShowAllItems()

@deprecated. Please use the ‘showAllItems’ property instead. Indicates whether to show all items even if there are no data or they are deleted. Default value is true;

getShowAllItems() : boolean;

setShowAllItems(boolean)

@deprecated. Please use the ‘showAllItems’ property instead. Indicates whether to show all items even if there are no data or they are deleted. Default value is true;

setShowAllItems(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getTitle()

@deprecated. Please use the ’title’ property instead. Specifies the title of the current Slicer object.

getTitle() : string;

Remarks

setTitle(string)

@deprecated. Please use the ’title’ property instead. Specifies the title of the current Slicer object.

setTitle(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

Remarks

getAlternativeText()

@deprecated. Please use the ‘alternativeText’ property instead. Returns or sets the descriptive (alternative) text string of the Slicer object.

getAlternativeText() : string;

Remarks

setAlternativeText(string)

@deprecated. Please use the ‘alternativeText’ property instead. Returns or sets the descriptive (alternative) text string of the Slicer object.

setAlternativeText(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

Remarks

isPrintable()

@deprecated. Please use the ‘isPrintable’ property instead. Indicates whether the slicer object is printable.

isPrintable() : boolean;

Remarks

setIsPrintable(boolean)

@deprecated. Please use the ‘isPrintable’ property instead. Indicates whether the slicer object is printable.

setIsPrintable(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Remarks

isLocked()

@deprecated. Please use the ‘isLocked’ property instead. Indicates whether the slicer shape is locked.

isLocked() : boolean;

Remarks

setIsLocked(boolean)

@deprecated. Please use the ‘isLocked’ property instead. Indicates whether the slicer shape is locked.

setIsLocked(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Remarks

getPlacement()

@deprecated. Please use the ‘placement’ property instead. Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.

getPlacement() : PlacementType;

Returns

PlacementType

Remarks

setPlacement(PlacementType)

setPlacement(value: PlacementType) : void;

Parameters:

Parameter	Type	Description
value	PlacementType	The value to set.

Remarks

getLockedAspectRatio()

@deprecated. Please use the ’lockedAspectRatio’ property instead. Indicates whether locking aspect ratio.

getLockedAspectRatio() : boolean;

Remarks

setLockedAspectRatio(boolean)

@deprecated. Please use the ’lockedAspectRatio’ property instead. Indicates whether locking aspect ratio.

setLockedAspectRatio(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Remarks

getLockedPosition()

@deprecated. Please use the ’lockedPosition’ property instead. Indicates whether the specified slicer can be moved or resized by using the user interface.

getLockedPosition() : boolean;

setLockedPosition(boolean)

@deprecated. Please use the ’lockedPosition’ property instead. Indicates whether the specified slicer can be moved or resized by using the user interface.

setLockedPosition(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getShape()

@deprecated. Please use the ‘shape’ property instead. Returns the Shape object associated with the specified slicer. Read-only.

getShape() : SlicerShape;

Returns

SlicerShape

getSlicerCache()

@deprecated. Please use the ‘slicerCache’ property instead. Returns the SlicerCache object associated with the slicer. Read-only.

getSlicerCache() : SlicerCache;

Returns

SlicerCache

getParent()

@deprecated. Please use the ‘parent’ property instead. Returns the Worksheet object which contains this slicer. Read-only.

getParent() : Worksheet;

Returns

Worksheet

Remarks

getWorksheet()

@deprecated. Please use the ‘worksheet’ property instead. Returns the Worksheet object which contains this slicer. Read-only.

getWorksheet() : Worksheet;

Returns

Worksheet

getStyleType()

@deprecated. Please use the ‘styleType’ property instead. Specify the type of Built-in slicer style. The default type is SlicerStyleLight1.

getStyleType() : SlicerStyleType;

Returns

SlicerStyleType

setStyleType(SlicerStyleType)

@deprecated. Please use the ‘styleType’ property instead. Specify the type of Built-in slicer style. The default type is SlicerStyleLight1.

setStyleType(value: SlicerStyleType) : void;

Parameters:

Parameter	Type	Description
value	SlicerStyleType	The value to set.

getName()

@deprecated. Please use the ’name’ property instead. Returns or sets the name of the specified slicer

getName() : string;

setName(string)

@deprecated. Please use the ’name’ property instead. Returns or sets the name of the specified slicer

setName(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

getCaption()

@deprecated. Please use the ‘caption’ property instead. Returns or sets the caption of the specified slicer.

getCaption() : string;

setCaption(string)

@deprecated. Please use the ‘caption’ property instead. Returns or sets the caption of the specified slicer.

setCaption(value: string) : void;

Parameters:

Parameter	Type	Description
value	string	The value to set.

getFirstItemIndex()

@deprecated. Please use the ‘firstItemIndex’ property instead. Specifies the zero-based index of the first slicer item.

getFirstItemIndex() : number;

setFirstItemIndex(number)

@deprecated. Please use the ‘firstItemIndex’ property instead. Specifies the zero-based index of the first slicer item.

setFirstItemIndex(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getCaptionVisible()

@deprecated. Please use the ‘captionVisible’ property instead. Returns or sets whether the header that displays the slicer Caption is visible. The default value is true

getCaptionVisible() : boolean;

Remarks

setCaptionVisible(boolean)

@deprecated. Please use the ‘captionVisible’ property instead. Returns or sets whether the header that displays the slicer Caption is visible. The default value is true

setCaptionVisible(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

Remarks

getShowCaption()

@deprecated. Please use the ‘showCaption’ property instead. Indicates whether the header of the slicer is visible. The default value is true

getShowCaption() : boolean;

setShowCaption(boolean)

@deprecated. Please use the ‘showCaption’ property instead. Indicates whether the header of the slicer is visible. The default value is true

setShowCaption(value: boolean) : void;

Parameters:

Parameter	Type	Description
value	boolean	The value to set.

getNumberOfColumns()

@deprecated. Please use the ’numberOfColumns’ property instead. Returns or sets the number of columns in the specified slicer. The default value is 1.

getNumberOfColumns() : number;

setNumberOfColumns(number)

@deprecated. Please use the ’numberOfColumns’ property instead. Returns or sets the number of columns in the specified slicer. The default value is 1.

setNumberOfColumns(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getLeftPixel()

@deprecated. Please use the ’leftPixel’ property instead. Returns or sets the horizontal offset of slicer shape from its left column, in pixels.

getLeftPixel() : number;

Remarks

setLeftPixel(number)

@deprecated. Please use the ’leftPixel’ property instead. Returns or sets the horizontal offset of slicer shape from its left column, in pixels.

setLeftPixel(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

getTopPixel()

@deprecated. Please use the ’topPixel’ property instead. Returns or sets the vertical offset of slicer shape from its top row, in pixels.

getTopPixel() : number;

Remarks

setTopPixel(number)

@deprecated. Please use the ’topPixel’ property instead. Returns or sets the vertical offset of slicer shape from its top row, in pixels.

setTopPixel(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

getWidth()

@deprecated. Please use the ‘width’ property instead. Returns or sets the width of the specified slicer, in points.

getWidth() : number;

Remarks

setWidth(number)

@deprecated. Please use the ‘width’ property instead. Returns or sets the width of the specified slicer, in points.

setWidth(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

getWidthPixel()

@deprecated. Please use the ‘widthPixel’ property instead. Returns or sets the width of the specified slicer, in pixels.

getWidthPixel() : number;

Remarks

setWidthPixel(number)

@deprecated. Please use the ‘widthPixel’ property instead. Returns or sets the width of the specified slicer, in pixels.

setWidthPixel(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

getHeight()

@deprecated. Please use the ‘height’ property instead. Returns or sets the height of the specified slicer, in points.

getHeight() : number;

Remarks

setHeight(number)

@deprecated. Please use the ‘height’ property instead. Returns or sets the height of the specified slicer, in points.

setHeight(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

getHeightPixel()

@deprecated. Please use the ‘heightPixel’ property instead. Returns or sets the height of the specified slicer, in pixels.

getHeightPixel() : number;

Remarks

setHeightPixel(number)

@deprecated. Please use the ‘heightPixel’ property instead. Returns or sets the height of the specified slicer, in pixels.

setHeightPixel(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

Remarks

getColumnWidthPixel()

@deprecated. Please use the ‘columnWidthPixel’ property instead. Gets or sets the width of each column in the slicer, in unit of pixels.

getColumnWidthPixel() : number;

setColumnWidthPixel(number)

@deprecated. Please use the ‘columnWidthPixel’ property instead. Gets or sets the width of each column in the slicer, in unit of pixels.

setColumnWidthPixel(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getColumnWidth()

@deprecated. Please use the ‘columnWidth’ property instead. Returns or sets the width of each column in the slicer in unit of points.

getColumnWidth() : number;

setColumnWidth(number)

@deprecated. Please use the ‘columnWidth’ property instead. Returns or sets the width of each column in the slicer in unit of points.

setColumnWidth(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getRowHeightPixel()

@deprecated. Please use the ‘rowHeightPixel’ property instead. Returns or sets the height of each row in the specified slicer, in unit of pixels.

getRowHeightPixel() : number;

setRowHeightPixel(number)

@deprecated. Please use the ‘rowHeightPixel’ property instead. Returns or sets the height of each row in the specified slicer, in unit of pixels.

setRowHeightPixel(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

getRowHeight()

@deprecated. Please use the ‘rowHeight’ property instead. Returns or sets the height of each row in the specified slicer in unit of points.

getRowHeight() : number;

setRowHeight(number)

@deprecated. Please use the ‘rowHeight’ property instead. Returns or sets the height of each row in the specified slicer in unit of points.

setRowHeight(value: number) : void;

Parameters:

Parameter	Type	Description
value	number	The value to set.

addPivotConnection(PivotTable)

Adds PivotTable connection.

addPivotConnection(pivot: PivotTable) : void;

Parameters:

Parameter	Type	Description
pivot	PivotTable	The PivotTable object

removePivotConnection(PivotTable)

Removes PivotTable connection.

removePivotConnection(pivot: PivotTable) : void;

Parameters:

Parameter	Type	Description
pivot	PivotTable	The PivotTable object

refresh()

Refreshing the slicer. Meanwhile, Refreshing and Calculating PivotTables which this slicer based on.

refresh() : void;

isNull()

Checks whether the implementation object is null.

isNull() : boolean;