GrapeCity.Documents.Excel.ISlicerCache

Interface ISlicerCache

Represents the current filter state for a slicer and information about which IPivotCache.

public interface ISlicerCache

Returns whether the slicer filter state is cleared. Boolean. Read-only.

bool FilterCleared { get; }

True if the slicer cache is for a slicer on a table. False otherwise. Boolean Read-only.

bool List { get; }

Returns or sets the name of the slicer cache.

string Name { get; set; }

Returns a ISlicerPivotTables collection that contains information about the PivotTables the slicer cache is currently filtering. Read-only.

ISlicerPivotTables PivotTables { get; }

Returns a ISlicerItemscollection that contains the collection of all items in the slicer cache. Read-only.

ISlicerItems SlicerItems { get; }

Returns a ISlicers collection that contains the collection of ISlicer objects associated with the specified ISlicerCache. Read-only.

ISlicers Slicers { get; }

Returns or sets the sort order of the items in the slicer. Read/write SlicerSortOrder.

SlicerSortOrder SortItems { get; set; }

Returns the name of the data source the slicer is connected to. Read-only.

string SourceName { get; }

Returns a ITable object associated with slicer. Read-only.

ITable Table { get; }

Clears the filter for slicer, depending on the slicer cache type.

void ClearAllFilters()

Deletes the specified slicer cache and the slicers associated with it.

void Delete()