GrapeCity.Spreadsheet.Slicers.ISlicerCache

ISlicerCache Interface

Represents the current filter state for a slicer and information about which source the slicer is connected to.

public interface ISlicerCache

Public Interface ISlicerCache

Name	Description
CrossFilterType	Gets or sets whether the slicer is participating in cross filtering with other slicers that share the same slicer cache, and how cross filtering is displayed.
FilterCleared	Gets a value indicating whether the filter state is cleared.
Index	Gets the index of the specified ISlicerCache object in the ISlicerCaches collection.
List	Gets a value indicating whether the slicer cache is for a slicer on a table.
ListObject	Gets the ITable object associated with this ISlicerCache.
Name	Gets or sets the name of the slicer cache.
RequireManualUpdate	Gets or sets a value indicating whether manual updates of the slicer cache required.
SlicerItems	Gets the ISlicerItems collection that contains the collection of all items in the slicer cache.
Slicers	Gets the ISlicers collection that contains the collection of ISlicer objects associated with the specified ISlicerCache.
SortItems	Gets or sets the sort order of the items in the slicer.
SourceName	Gets the name of the data source the slicer is connected to.
VisibleSlicerItems	Gets the ISlicerItems collection that contains the collection of all the visible items in the specified slicer cache.

Name	Description
ClearAllFilters()	Clears the filter depending on the slicer cache type.
ClearDateFilter()	Clears the filter for a timeline (date filter).
ClearManualFilter()	Clears the manual filter for the slicer cache.
Delete()	Deletes the specified slicer cache and the slicers associated with it.