Ctrl+F does not work with spreadjs sheets

Ctrl+F does not work with spreadjs sheets

Posted by: jose.kurian on 12 February 2018, 8:54 am EST

• 

  jose.kurian

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 February 2018, 8:54 am EST

  Hi
  
  Ctrl+F does not work with spreadjs sheets. Any way to get this working?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  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

• 

  sreeharsha.macha

  • Post Options:
  • Link
    Copy

  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

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  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.

  sample 1: https://jscodemine.grapecity.com/share/s2Vta13W-0eo2mJiDLHPlg/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp-func.jsx"%2C"%2Fsrc%2Fapp.jsx"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp-func.jsx"}

  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