SearchFlags Enumeration

Specifies the type of search flags.

Members

Member	Description
BlockRange	Determines whether to search within a cell range.
ExactMatch	Determines whether the search considers only an exact match.
IgnoreCase	Determines whether the search considers the case of the letters in the search string.
None	None
UseWildCards	Determines whether the search considers wildcard characters (*, ?) in the search string.

Example

This example uses the SearchFlags 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.SearchFlags

Reference

GcSpread.Sheets Namespace
Searching Data