You can search for a string in the widget and specify options such as the case, exact match, wild cards, cell range to search, and the order to search in. You can search cell text, cell tags, or formulas.
You can use the search method and the SearchCondition class to find items in code.
This example searches for a specific text string.
JavaScript |
Copy Code
|
---|---|
activeSheet.getCell(2,3).value("testSearch"); searchCondition.searchOrder = GC.Spread.Sheets.Search.SearchOrder.NOrder; var str ="[searchFoundFlag:"+ searchresult.searchFoundFlag+",\r\n foundSheetIndex:"+searchresult.foundSheetIndex+",foundRowIndex:" + |