GrapeCity.Documents.Excel.IFilter.On

On Property

On

Gets whether the specified filter is enabled.

This property indicates whether the filter for the current column is enabled in the worksheet's auto filter.

Declaration

bool On { get; }

ReadOnly Property [On] As Boolean

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"Apple", 100},
    {"Banana", 200},
    {"Cherry", 100}
};
worksheet.Range["A1:B4"].AutoFilter(1, "100");
IFilter filter = worksheet.AutoFilter.Filters[1];
bool on = filter.On;