Slow filters when import from Excel

Slow filters when import from Excel

Posted by: marcio.shimoda on 11 January 2023, 9:32 am EST

• 

  marcio.shimoda

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 January 2023, 9:32 am EST

  I have an Excel spreadsheet with some filters and after importing, when I filter a value, the SpreaJS takes a while show the results. I realized that in version 16 this is not happening.

  This problem could be related to the issue mentioned in release notes (“SpreadJS has resolved the performance issue where the Excel import got slower than v13.”) ? Is there anything that can be done to improve the performance of these filters?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 12 January 2023, 1:05 am EST

  Hi,

  Yes, The V16 has performance enhancements. We suggest you to upgrade top the latest build to get best performance experience.

  Further for workaround in you version we need investigate the file on which you are facing the issue. Could you please share the version that you using and the excel so that we could investigate it further and help you accordingly.

  Regards,
  
  Avinash

• 

  marcio.shimoda

  • Post Options:
  • Link
    Copy

  Posted 12 January 2023, 1:03 pm EST

  Hi Avinash

  we are currently using 15.1.4 version.

  Teste_6_anon.zip

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 13 January 2023, 7:34 am EST

  HI,

  Thanks for the sample file. We don’t have any fix to 15.1.3 but you may update to 15.2.3 to fix this issue.

  Regards,
  
  Avinash

• 

  marcio.shimoda

  • Post Options:
  • Link
    Copy

  Posted 16 January 2023, 11:07 am EST

  We’ve updated to version 15.2.3 and now it’s working perfectly.
  
  Thanks!