SearchCondition type

Defines the search condition.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Search.SearchCondition();

function SearchCondition;

Example

Javascript

activeSheet.getCell(5,4).text("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= spread.search(searchCondition);
var str ="[searchFoundFlag:"+ searchresult.searchFoundFlag+",\r\n foundSheetIndex:"+searchresult.foundSheetIndex+",foundRowIndex:" + searchresult.foundRowIndex+", * foundColumnIndex:"+searchresult.foundColumnIndex+", foundString:"+searchresult.foundString+"]";
alert(str);

Inheritance Hierarchy

Object
GC.Spread.Sheets.Search.SearchCondition

Constructors

	Name	Description
	SearchCondition Constructor	Defines the search condition.

Top

Fields

	Name	Description
	columnEnd	The index of the column at which to end.
	columnStart	The index of the column at which to start.
	endSheetIndex	Index of the sheet on which to end searching.
	rowEnd	The index of the row at which to end.
	rowStart	The index of the row at which to start.
	searchFlags	The enumeration that specifies the options of the search.
	searchOrder	The enumeration that specifies whether the search goes by coordinates of (column, row) or (row, column).
	searchString	The string for which to search.
	searchTarget	The enumeration that indicates whether the search includes the content in the cell notes, tags, or text.
	sheetArea	The area of the sheet for search.
	startSheetIndex	Index of the sheet on which to start searching.

Top

Reference

GC.Spread.Sheets.Search Namespace