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


In This Topic
    AlternateSearch Property
    In This Topic
    Gets or sets whether to search down rows first then across columns, which is the alternate way of searching.
    Syntax
    'Declaration
     
    Public Overridable Property AlternateSearch As Boolean
    'Usage
     
    Dim instance As SearchDialog
    Dim value As Boolean
     
    instance.AlternateSearch = value
     
    value = instance.AlternateSearch
    public virtual bool AlternateSearch {get; set;}

    Property Value

    Boolean: true to search down rows and across columns; false to search across columns and down rows
    Example
    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