SearchWithDialog(Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32) Method
Searches the text in the cells of the specified sheet for the specified string with the specified criteria using a provided search dialog.
'Declaration
Public Overloads Sub SearchWithDialog( _
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 sheetIndex 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.SearchWithDialog(sheetIndex, searchString, caseSensitive, exactMatch, alternateSearch, useWildcards, startRowIndex, startColumnIndex)
Parameters
- sheetIndex
- Sheet index on which to search
- searchString
- String for which to search
- caseSensitive
- Whether the search considers the case of the letters in the search string
- exactMatch
- Whether the search considers only an exact match
- alternateSearch
- Whether the search goes by alternate coordinates of column, row (instead of row, column)
- useWildcards
- Whether the search considers wildcard characters (*, ?) in the search string
- startRowIndex
- Row index at which to start
- startColumnIndex
- Column index at which to start