Spread Windows Forms 11.0 Product Documentation
AlternateSearch Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SearchDialog Class : AlternateSearch Property
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

Reference

SearchDialog Class
SearchDialog Members