Posted 12 February 2018, 8:54 am EST
Hi
Ctrl+F does not work with spreadjs sheets. Any way to get this working?
Forums Home / Spread / SpreadJS
Posted by: jose.kurian on 12 February 2018, 8:54 am EST
Posted 12 February 2018, 8:54 am EST
Hi
Ctrl+F does not work with spreadjs sheets. Any way to get this working?
Posted 13 February 2018, 2:27 am EST
Hello,
You would need to handle the keyDown/keypress event manually and perform search using the Search method for SpreadJS:
http://help.grapecity.com/spread/SpreadSheets11/webframe.html#SpreadJS~GC.Spread.Sheets.Workbook~search.html
Thanks,
Deepak Sharma
Posted 22 January 2024, 10:31 pm EST
Hi,
But it searches only first available string in the sheet. How to search all available strings matched with search string. And it is not highlighting the matched word in the sheet
Posted 23 January 2024, 5:32 pm EST - Updated 23 January 2024, 5:37 pm EST
Hi,
Based on my understanding, you seem to be using the searching feature in SpreadJS.
By default, the search() method of the Workbook and Worksheet class returns the first matching result of the given search condition. If you want to get all matching results in the worksheet or workbook, you would need to manually modify the search range accordingly. So, that all the matching results could be found.
Please refer to the below samples for more understanding.
The above sample shows how all the matching search results could be obtained.
sample 2: sample.zip
Use commands “npm i” and “npm start” to install dependencies and run the sample.
The above sample demonstrates searching strings in the workbook.
Please refer to the attached GIF for searching values in the workbook in SpreadJS Designer.
If you still face any issues, please let us know.
References:
workbook.search(): https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Workbook#search
worksheet.search(): https://developer.mescius.com/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#search
Regards