AlternateSearch Property

Gets or sets whether to search down rows first then across columns, which is the alternate way of searching.

Syntax

Visual Basic
C#

'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;

Visual Basic

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

Reference

SearchDialog Class
SearchDialog Members