SearchWithDialogAdvanced(Int32,Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32) Method
In This Topic
Searches the text in the cells of the specified sheet range for the specified string with the specified criteria using a provided advanced search dialog.
Syntax
'Declaration
Public Overloads Sub SearchWithDialogAdvanced( _
ByVal As Integer, _
ByVal As Integer, _
ByVal As String, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Boolean, _
ByVal As Integer, _
ByVal startColumnIndex As Integer _
)
'Usage
Dim instance As FpSpread
Dim startSheetIndex As Integer
Dim endSheetIndex As Integer
Dim searchString As String
Dim caseSensitive As Boolean
Dim exactMatch As Boolean
Dim alternateSearch As Boolean
Dim useWildcards As Boolean
Dim startRowIndex As Integer
Dim startColumnIndex As Integer
instance.SearchWithDialogAdvanced(startSheetIndex, endSheetIndex, searchString, caseSensitive, exactMatch, alternateSearch, useWildcards, startRowIndex, startColumnIndex)
public void SearchWithDialogAdvanced(
int ,
int ,
string ,
bool ,
bool ,
bool ,
bool ,
int ,
int startColumnIndex
)
Parameters
- startSheetIndex
- Sheet index on which to start the search
- endSheetIndex
- Sheet index on which to end the search
- searchString
- String for which to search
- caseSensitive
- Whether search should consider the case of the letters in the search string
- exactMatch
- Whether the search should consider only an exact match
- alternateSearch
- Whether search goes by alternate coordinates of column, row (instead of row, column)
- useWildcards
- Whether search considers wildcard characters (*, ?) in the search string
- startRowIndex
- Row index at which to start
- startColumnIndex
- Column index at which to start
See Also