GrapeCity.Documents.Excel.IAutoFilter.ShowAllData

ShowAllData Method

ShowAllData()

Clears the applied filter criteria and displays all data in the current AutoFilter range.

Makes all rows in the current AutoFilter range visible again by clearing the applied filter criteria.

Declaration

void ShowAllData()

Sub ShowAllData()

Examples

IRange range = worksheet.Range["A1:B4"];
range.Value = new object[,] {{"Name", "Value"}, {"A", 100}, {"B", 200}, {"C", 50}};
range.AutoFilter(1, ">=100");
IAutoFilter autoFilter = worksheet.AutoFilter;
autoFilter.ShowAllData();