Click or drag to resize

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
)

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