Spread.Sheets Documentation
SearchFoundFlags Enumeration
GC.Spread.Sheets.Search Namespace : SearchFoundFlags Enumeration
Specifies where the search string is found.
Members
MemberDescription
cellFormulaIndicates that the string is found in the cell formula.
cellTagIndicates that the string is found in the cell tag.
cellTextIndicates that the string is found in the cell text.
noneIndicates that no string is found.
Example
This example uses the SearchFoundFlags 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.SearchFoundFlags

See Also

Reference

GC.Spread.Sheets.Search Namespace
Searching Data