var instance = new GC.Spread.Sheets.Search.SearchCondition();
function SearchCondition;
var instance = new GC.Spread.Sheets.Search.SearchCondition();
function SearchCondition;
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);
Object
GC.Spread.Sheets.Search.SearchCondition
Name | Description | |
---|---|---|
![]() | SearchCondition Constructor | Defines the search condition. |
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. |