GrapeCity.Documents.Excel.AutoFilterOperator

AutoFilterOperator Enum

Specifies the operator or filter type used by AutoFilter criteria.

Use this enum with AutoFilter(int, object, AutoFilterOperator, object, bool) to specify how the range should be filtered.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum AutoFilterOperator

Public Enum AutoFilterOperator

Examples

worksheet.Range["A1:B5"].Value = new object[,] {
    {"Name", "Score"},
    {"Alice", 80},
    {"Bob", 120},
    {"Carol", 180},
    {"David", 220}
};
worksheet.Range["A1:B5"].AutoFilter(1, ">=100", AutoFilterOperator.And, "<=200");

Fields

Name	Description
And	Specifies logical AND of Criteria1 and Criteria2.
AutomaticFontColor	Specifies that this is reserved for internal use.
Bottom10Items	Specifies that the lowest-valued items are displayed (number of items specified in Criteria1).
Bottom10Percent	Specifies that the lowest-valued items are displayed (percentage specified in Criteria1).
CellColor	Specifies the cell color.
Dynamic	Specifies the dynamic filter.
FontColor	Specifies the font color.
Icon	Specifies the filter icon.
NoFill	Specifies that this is reserved for internal use.
NoIcon	Specifies that this is reserved for internal use.
None	Specifies the default.
Or	Specifies logical OR of Criteria1 and Criteria2.
Top10Items	Specifies that the highest-valued items are displayed (number of items specified in Criteria1).
Top10Percent	Specifies that the highest-valued items are displayed (percentage specified in Criteria1).
Values	Specifies filter values.