Slowness problems when thousand of rows are hidden

Slowness problems when thousand of rows are hidden

Posted by: sebastien.vincent on 12 April 2022, 2:15 pm EST

• 

  sebastien.vincent

  • Post Options:
  • Link
    Copy

  Posted 12 April 2022, 2:15 pm EST

  Hello,

  We noticed a problem with SpreadJS. We have large MsExcel files, around 50,000 lines. When in an Excel sheet, there are thousands of hidden rows, SpreadJS seems to no longer respond adequately and we notice slowness problems.

  You can reproduce the problem with the two attached files. One file contains 50000 visible lines, the other file has the majority of its lines hidden so you can notice the difference in behavior in SpreadJS.

  We noticed the same problem on the online Demo site.
  
  examples.zip

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 13 April 2022, 6:08 am EST

  Hi,

  We are able to replicate the issue at our end hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team. This internal ID for this issue will be SJS-12644.

  Regards,
  
  Avinash

• 

  pdoxakis

  • Post Options:
  • Link
    Copy

  Posted 13 April 2022, 1:30 pm EST

  Hi,

  I would like to mention another situation really similar. When using filter and there are a lot of hidden rows shown on the screen, we can also see the slowness. But, when scrolling to a zone where there is no hidden row, it is much faster. I suppose it try to do the rendering of all the visible rows (including the hidden one)

  test with filter.zip

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 19 April 2022, 5:45 am EST

  Hi,

  Thanks for the information. The devs are investigating this issue. We will update you regarding this as we get any information from the team.

  Regards,
  
  Avinash