ExcelAutoFilterOperator Enumeration |
The comparison operator of an AutoFilter custom condition.
Namespace: ExpertXls.ExcelLibAssembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntaxpublic enum ExcelAutoFilterOperator
Public Enumeration ExcelAutoFilterOperator
Members| Member name | Value | Description |
|---|
| EqualTo | 0 |
The cell is equal to the value. A text value can contain the * and ? wildcards.
|
| NotEqualTo | 1 |
The cell is not equal to the value. A text value can contain the * and ? wildcards.
|
| GreaterThan | 2 |
The cell is greater than the value.
|
| GreaterThanOrEqualTo | 3 |
The cell is greater than or equal to the value.
|
| LessThan | 4 |
The cell is less than the value.
|
| LessThanOrEqualTo | 5 |
The cell is less than or equal to the value.
|
| BeginsWith | 6 |
The cell text begins with the value.
|
| EndsWith | 7 |
The cell text ends with the value.
|
| Contains | 8 |
The cell text contains the value.
|
| DoesNotContain | 9 |
The cell text does not contain the value.
|
See Also