SearchCondition type

Defines the search condition.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.SearchCondition();

function SearchCondition;

Example

This example creates a new search condition.

Javascript

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= spread.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.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

GcSpread.Sheets Namespace
Searching Data