SearchFoundFlags Enumeration

Specifies where the search string is found.

Members

Member	Description
cellFormula	Indicates that the string is found in the cell formula.
cellTag	Indicates that the string is found in the cell tag.
cellText	Indicates that the string is found in the cell text.
none	Indicates that no string is found.

Example

This example uses the SearchFoundFlags enumeration.

Javascript

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

Reference

GC.Spread.Sheets.Search Namespace
Searching Data