GrapeCity.Documents.Excel.IWorksheet.FilterMode

FilterMode Property

FilterMode

Gets whether the worksheet is currently in filter mode.

Filter mode indicates that a filter has been applied and the worksheet is actively filtering data. This differs from AutoFilterMode, which indicates whether AutoFilter is enabled on the worksheet.

Declaration

bool FilterMode { get; }

ReadOnly Property FilterMode As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 100},
    {"B", 200},
    {"C", 100}
};
worksheet.Range["A1:B4"].AutoFilter(1, 100);
bool filterMode = worksheet.FilterMode;