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


In This Topic
    SearchWithDialog(Int32,String,Boolean,Boolean,Boolean,Boolean,Int32,Int32) Method
    In This Topic
    Searches the text in the cells of the specified sheet for the specified string with the specified criteria using a provided search dialog.
    Syntax
    'Declaration
     
    Public Overloads Sub SearchWithDialog( _
       ByVal sheetIndex 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 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)
    public void SearchWithDialog( 
       int sheetIndex,
       string searchString,
       bool caseSensitive,
       bool exactMatch,
       bool alternateSearch,
       bool useWildcards,
       int startRowIndex,
       int 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
    Remarks

    Refer to the restrictions listed in the SearchWithDialog methods.

    Example
    This example opens a search dialog with the settings predetermined. The user can still change them before performing the search.
    fpSpread1.SearchWithDialog(0,"This",true,false,false,false,0,0);
    FpSpread1.SearchWithDialog(0,"This",true,false,false,false,0,0);
    See Also