Find and Replace SpreadJS Designer

Find and Replace SpreadJS Designer

Posted by: dhruv.barad on 18 March 2024, 1:51 am EST

• 

  dhruv.barad

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 March 2024, 1:51 am EST

  Hello,

  I am having trouble with the current find and replace function in SpreadJS Designer. We have added a custom “Reset” button that resets the spreadsheet to the original state (can be blank or predefined). The issue is that after the reset, when we try to do find and replace, it only searches through the previous version of the spreadsheet (before the reset). For example, if the spreadsheet has 2 cells with value “abc”, after the reset when you search for “abc” again, it will give us the results for spreadsheet before the reset. My question: Is there a way to clear the cache results for find and replace option?

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 18 March 2024, 10:29 pm EST - Updated 18 March 2024, 10:34 pm EST

  Hi,

  I have tested with the latest version of SpreadJS V17.0.4 and it seems to be working fine and I was unable to reproduce the issue. Kindly refer to the following sample that I have used for testing.

  Sample: https://jscodemine.mescius.io/share/PggRazdi90OQKuv1KFzNBg/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  This is the code I am using to reset the worksheets:

      for (let i = 0; i < spread.getSheetCount(); i++) {
          let sheetRef = spread.getSheet(i);
          // Reset all the sheets
          sheetRef.reset();
      }
  

  Could you kindly share us a minimal working sample replicating the issue? You may also modify the above sample and share it with us replicating the issue.

  reset method: https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Worksheet#reset

  Regards,

  Ankit

  

• 

  dhruv.barad

  • Post Options:
  • Link
    Copy

  Posted 19 March 2024, 5:51 am EST

  Thanks Ankit. Looks like we figured out the issue.

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 19 March 2024, 3:18 pm EST

  Hi,

  We are happy that the issue is resolved. Let us know if you face any issues related to it. For other issues/queries, feel free to create new ticket/topic.

  Regards,

  Ankit