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 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= 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
GcSpread.Sheets.SearchFoundFlags

Reference

GcSpread.Sheets Namespace
Searching Data