Spread Windows Forms 12.0 Product Documentation
AutoFilter(Int32,Object,AutoFilterOperator,Object) Method


GrapeCity.Spreadsheet Assembly > GrapeCity.Spreadsheet Namespace > IRange Interface > AutoFilter Method : AutoFilter(Int32,Object,AutoFilterOperator,Object) Method
Index of the column.
The first criteria is corresponding the first filter criteria.
The value specifying the type of filter.
The second criteria is corresponding the second filter criteria.
Filters a list using the AutoFilter.
Syntax
'Declaration
 
Overloads Function AutoFilter( _
   ByVal columnIndex As Integer, _
   Optional ByVal criteria1 As Object, _
   Optional ByVal filterOperator As AutoFilterOperator, _
   Optional ByVal criteria2 As Object _
) As Boolean
'Usage
 
Dim instance As IRange
Dim columnIndex As Integer
Dim criteria1 As Object
Dim filterOperator As AutoFilterOperator
Dim criteria2 As Object
Dim value As Boolean
 
value = instance.AutoFilter(columnIndex, criteria1, filterOperator, criteria2)

Parameters

columnIndex
Index of the column.
criteria1
The first criteria is corresponding the first filter criteria.
filterOperator
The value specifying the type of filter.
criteria2
The second criteria is corresponding the second filter criteria.
Remarks
If filterOperator is AutoFilterOperator.FilterValues, criteria1 can be string[] or DateGroupItem[] array.
See Also

Reference

IRange Interface
IRange Members
Overload List