Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet.Commands Namespace / FilterCommand Class / FilterCommand Constructor
The effected filter.
Relative filter column index
Filter action
The first condition
Filter operator
The second condition
Worksheet
Filter range


In This Topic
FilterCommand Constructor
In This Topic
Initializes a new instance of the FilterCommand class.
Syntax
'Declaration
 
Public Function New( _
   ByVal autoFilter As IAutoFilter, _
   ByVal columnIndex As Integer, _
   ByVal action As AutoFilterActions, _
   Optional ByVal criteria1 As Object, _
   Optional ByVal filterOperator As AutoFilterOperator, _
   Optional ByVal criteria2 As Object, _
   Optional ByVal worksheet As IWorksheet, _
   Optional ByVal range As Reference _
)
 
'Usage
 
Dim autoFilter As IAutoFilter
Dim columnIndex As Integer
Dim action As AutoFilterActions
Dim criteria1 As Object
Dim filterOperator As AutoFilterOperator
Dim criteria2 As Object
Dim worksheet As IWorksheet
Dim range As Reference
 
Dim instance As New FilterCommand(autoFilter, columnIndex, action, criteria1, filterOperator, criteria2, worksheet, range)

Parameters

autoFilter
The effected filter.
columnIndex
Relative filter column index
action
Filter action
criteria1
The first condition
filterOperator
Filter operator
criteria2
The second condition
worksheet
Worksheet
range
Filter range
See Also