Spread.Sheets Documentation
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.
nonenone
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

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.