Spread.Sheets Documentation
SearchOrder Enumeration
GC.Spread.Sheets.Search Namespace : SearchOrder Enumeration
Specifies the type of search direction.
Members
MemberDescription
nOrderDetermines whether the search goes by row, column coordinates.
zOrderDetermines whether the search goes by column, row coordinates.
Example
This example creates a new search condition and sets the search order.
activeSheet.getCell(2,3).value("testSearch");
var searchCondition = new GC.Spread.Sheets.Search.SearchCondition();
searchCondition.searchString = "testSearch";
searchCondition.startSheetIndex = spread.getActiveSheetIndex();
searchCondition.endSheetIndex = spread.getActiveSheetIndex();

searchCondition.searchOrder = GC.Spread.Sheets.Search.SearchOrder.nOrder;
searchCondition.searchTarget = GC.Spread.Sheets.Search.SearchFoundFlags.cellText;
searchCondition.searchFlags = GC.Spread.Sheets.Search.SearchFlags.ignoreCase| GC.Spread.Sheets.Search.SearchFlags.useWildCards;
var searchresult= spread.search(searchCondition);

var str ="[searchFoundFlag:"+ searchresult.searchFoundFlag+",\r\n foundSheetIndex:"+searchresult.foundSheetIndex+",foundRowIndex:" +
searchresult.foundRowIndex+", foundColumnIndex:"+searchresult.foundColumnIndex+", foundString:"+searchresult.foundSheetIndex+"]";
alert(str);
Inheritance Hierarchy

Object
   GC.Spread.Sheets.Search.SearchOrder

See Also

Reference

GC.Spread.Sheets.Search Namespace
Searching Data