Slicer Class
Contents
[
Hide
]Slicer class
summary description of Slicer View
type Slicer struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| GetSortOrderType | Indicates the type of sorting items. |
| SetSortOrderType | Indicates the type of sorting items. |
| GetShowMissing | Indicates whether to show items deteleted from the data source. |
| SetShowMissing | Indicates whether to show items deteleted from the data source. |
| GetShowTypeOfItemsWithNoData | Indicates whether to show items deteleted from the data source. |
| SetShowTypeOfItemsWithNoData | Indicates whether to show items deteleted from the data source. |
| GetShowAllItems | Indicates whether to show all items even if there are no data or they are deleted.Default value is true; |
| SetShowAllItems | Indicates whether to show all items even if there are no data or they are deleted.Default value is true; |
| AddPivotConnection | Adds PivotTable connection. |
| RemovePivotConnection | Removes PivotTable connection. |
| GetLockedPosition | Indicates whether the specified slicer can be moved or resized by using the user interface. |
| SetLockedPosition | Indicates whether the specified slicer can be moved or resized by using the user interface. |
| Refresh | Refreshing the slicer.Meanwhile, Refreshing and Calculating PivotTables which this slicer based on. |
| GetShape | Returns the Shape object associated with the specified slicer. Read-only. |
| GetSlicerCache | Returns the SlicerCache object associated with the slicer. Read-only. |
| GetWorksheet | Returns the Worksheet object which contains this slicer. Read-only. |
| GetStyleType | Specify the type of Built-in slicer style.The default type is SlicerStyleLight1. |
| SetStyleType | Specify the type of Built-in slicer style.The default type is SlicerStyleLight1. |
| GetName | Returns or sets the name of the specified slicer |
| SetName | Returns or sets the name of the specified slicer |
| GetCaption | Returns or sets the caption of the specified slicer. |
| SetCaption | Returns or sets the caption of the specified slicer. |
| GetFirstItemIndex | Specifies the zero-based index of the first slicer item. |
| SetFirstItemIndex | Specifies the zero-based index of the first slicer item. |
| GetShowCaption | Indicates whether the header of the slicer is visible.The default value is true |
| SetShowCaption | Indicates whether the header of the slicer is visible.The default value is true |
| GetNumberOfColumns | Returns or sets the number of columns in the specified slicer.The default value is 1. |
| SetNumberOfColumns | Returns or sets the number of columns in the specified slicer.The default value is 1. |
| GetColumnWidthPixel | Gets or sets the width of each column in the slicer, in unit of pixels. |
| SetColumnWidthPixel | Gets or sets the width of each column in the slicer, in unit of pixels. |
| GetColumnWidth | Returns or sets the width of each column in the slicer in unit of points. |
| SetColumnWidth | Returns or sets the width of each column in the slicer in unit of points. |
| GetRowHeightPixel | Returns or sets the height of each row in the specified slicer, in unit of pixels. |
| SetRowHeightPixel | Returns or sets the height of each row in the specified slicer, in unit of pixels. |
| GetRowHeight | Returns or sets the height of each row in the specified slicer in unit of points. |
| SetRowHeight | Returns or sets the height of each row in the specified slicer in unit of points. |