Spread Windows Forms 17
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SearchWithDialogAdvanced Method / SearchWithDialogAdvanced(Int32,Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32) Method
Sheet index on which to start the search
Sheet index on which to end the search
String for which to search
Whether search should consider the case of the letters in the search string
Whether the search should consider only an exact match
Whether search goes by alternate coordinates of column, row (instead of row, column)
Whether search considers wildcard characters (*, ?) in the search string
Row index at which to start
Column index at which to start


In This Topic
    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 startSheetIndex As Integer, _
       ByVal endSheetIndex As Integer, _
       ByVal searchString As String, _
       ByVal caseSensitive As Boolean, _
       ByVal exactMatch As Boolean, _
       ByVal alternateSearch As Boolean, _
       ByVal useWildcards As Boolean, _
       ByVal startRowIndex 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)

    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