SpreadJS Documentation
searchOrder Field
The enumeration that specifies whether the search goes by coordinates of (column, row) or (row, column).
Syntax
var instance = new GcSpread.Sheets.SearchCondition();
var value; // Type: SearchOrder
value = instance.searchOrder;
var searchOrder : SearchOrder;
Example
This example sets the searchOrder property.
activeSheet.getCell(5,4).text("testSearch");
var searchCondition = new GcSpread.Sheets.SearchCondition();
searchCondition.searchString = "testSearch";
searchCondition.startSheetIndex = spread.getActiveSheetIndex();
searchCondition.endSheetIndex = spread.getActiveSheetIndex();
searchCondition.searchOrder = GcSpread.Sheets.SearchOrder.NOrder;
searchCondition.searchTarget = GcSpread.Sheets.SearchFoundFlags.CellText;
searchCondition.searchFlags = GcSpread.Sheets.SearchFlags.Ignorecase| GcSpread.Sheets.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.foundString+"]";
alert(str);
See Also

Reference

SearchCondition type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.