GrapeCity.Documents.Excel.ISlicerCache.ClearAllFilters

ClearAllFilters Method

ClearAllFilters()

Clears all filters applied through this slicer cache.

This method removes the current slicer filter state and restores the display of all items according to the slicer cache type.

Declaration

void ClearAllFilters()

Sub ClearAllFilters()

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 cache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
cache.SlicerItems["Vegetables"].Selected = false;
cache.ClearAllFilters();