GrapeCity.Documents.Excel.IFilter.Operator

Operator Property

Operator

Gets the operator that connects the two criteria used by the specified filter.

Use this value to determine how the filter combines its criteria, such as And or Or.

Declaration

AutoFilterOperator Operator { get; }

ReadOnly Property [Operator] As AutoFilterOperator

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Name", "Value"},
    {"A", 80},
    {"B", 150},
    {"C", 220}
};
worksheet.Range["A1:B4"].AutoFilter(1, ">100", AutoFilterOperator.And, "<200");
IFilter filter = worksheet.AutoFilter.Filters[1];
AutoFilterOperator filterOperator = filter.Operator;