Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / SearchDialog Property
Example


In This Topic
    SearchDialog Property
    In This Topic
    Gets the dialog associated with searching for text in a cell of a sheet in this component.
    Syntax
    'Declaration
     
    Public ReadOnly Property SearchDialog As SearchDialog
    'Usage
     
    Dim instance As FpSpread
    Dim value As SearchDialog
     
    value = instance.SearchDialog
    public SearchDialog SearchDialog {get;}

    Property Value

    SearchDialog object containing the search dialog
    Remarks

    The search has these qualifications:

    • This method only searches the cells in the data area, not the headers.
    • This method only checks against the formatted string -- the Text in the cell, not the Value.
    • This method only searches the specified cells in one sheet.
    • All the cells that contain data that can be represented as a string by the Text property of that cell are searched and that includes hidden and locked cells.
    • Cell notes and cell tags are not part of the search.

    This property is available at run time only.

    Example
    This example sets up the search dialog.
    fpSpread1.SearchWithDialog(""); 
    fpSpread1.SearchDialog.AlternateSearch = true; 
    fpSpread1.SearchDialog.CaseSensitive = false; 
    fpSpread1.SearchDialog.ExactMatch = false;  
    fpSpread1.SearchDialog.SearchString = "155"; 
    fpSpread1.SearchDialog.SheetIndex = 0; 
    fpSpread1.SearchDialog.StartColumnIndex = 0; 
    fpSpread1.SearchDialog.StartRowIndex = 0; 
    fpSpread1.SearchDialog.UseWildcards = false;  
    
    FpSpread1.SearchWithDialog("") 
    FpSpread1.SearchDialog.AlternateSearch = True 
    FpSpread1.SearchDialog.CaseSensitive = False 
    FpSpread1.SearchDialog.ExactMatch = False 
    FpSpread1.SearchDialog.SearchString = "155" 
    FpSpread1.SearchDialog.SheetIndex = 0 
    FpSpread1.SearchDialog.StartColumnIndex = 0 
    FpSpread1.SearchDialog.StartRowIndex = 0 
    FpSpread1.SearchDialog.UseWildcards = False  
    See Also