Spread.Sheets Documentation
SearchFlags Enumeration
GC.Spread.Sheets.Search Namespace : SearchFlags Enumeration
Specifies the type of search flags.
Members
MemberDescription
blockRangeDetermines whether to search within a cell range.
exactMatchDetermines whether the search considers only an exact match.
ignoreCaseDetermines whether the search considers the case of the letters in the search string.
noneSpecifies no search flags.
useWildCardsDetermines whether the search considers wildcard characters (*, ?) in the search string.
Example
This example uses the SearchFlags enumeration.
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= activeSheet.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.SearchFlags

See Also

Reference

GC.Spread.Sheets.Search Namespace
Searching Data