GrapeCity.Documents.Excel.ISlicerCache.FilterCleared

FilterCleared Property

FilterCleared

Gets whether the slicer cache filter state is cleared.

Returns true when no slicer items in the cache are excluded by filtering. This value becomes true after calling ClearAllFilters().

Declaration

bool FilterCleared { get; }

ReadOnly Property FilterCleared As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetables", 200},
    {"Fruit", 150}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicerCache slicerCache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
bool filterCleared = slicerCache.FilterCleared;