AutoFiltersCollection
CustomFilter Method (FilterColumn, FilterOperatorType, Object, Boolean, FilterOperatorType, Object)
|
Applies a custom filter to a specified column using two sets of criteria and logical operators.
Namespace:
Spire.Xls.Collections
Assembly:
Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public void CustomFilter(
FilterColumn column,
FilterOperatorType operatorType1,
Object criteria1,
bool isAnd,
FilterOperatorType operatorType2,
Object criteria2
)
Public Sub CustomFilter (
column As FilterColumn,
operatorType1 As FilterOperatorType,
criteria1 As Object,
isAnd As Boolean,
operatorType2 As FilterOperatorType,
criteria2 As Object
)
public:
void CustomFilter(
FilterColumn^ column,
FilterOperatorType operatorType1,
Object^ criteria1,
bool isAnd,
FilterOperatorType operatorType2,
Object^ criteria2
)
member CustomFilter :
column : FilterColumn *
operatorType1 : FilterOperatorType *
criteria1 : Object *
isAnd : bool *
operatorType2 : FilterOperatorType *
criteria2 : Object -> unit
Parameters
-
column
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
FilterColumn
The column to which the filter will be applied.
-
operatorType1
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
FilterOperatorType
The first logical operator to use for filtering.
-
criteria1
-
Type:
System
Object
The first criteria to apply in the filter.
-
isAnd
-
Type:
System
Boolean
Determines whether to use an AND or OR logical operator between the two criteria.
-
operatorType2
-
Type:
Spire.Xls.Core.Spreadsheet.AutoFilter
FilterOperatorType
The second logical operator to use for filtering.
-
criteria2
-
Type:
System
Object
The second criteria to apply in the filter.
See Also