Performance in larger workbooks

Performance in larger workbooks

Posted by: earl on 29 September 2021, 10:25 pm EST

• 

  earl

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 September 2021, 10:25 pm EST

  Good day Team,

  We’ve been following the remarkable improvements SpreadJS has achieved over the years. We currently use an internally developed control, but are looking at utilising SpreadJS for it’s more complete feature list.

  SpreadJS opens our files fine, but noticed degraded performance on specifically two large sheets (navigation as well as opening/closing of the groupings). Please find example attached.

  Anyway this can be improved upon?

  Thanks in advance!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 September 2021, 10:41 pm EST

  Hi,

  Looks like the file isn’t attached. Could you please provide the file on which you are facing this issue so that we could investigate it further and assist you accordingly?

  Regards
  
  Avinash

• 

  earl

  • Post Options:
  • Link
    Copy

  Posted 5 October 2021, 1:24 am EST

  Hi Avinash,

  Please find attached, I think its due to the hidden rows, and the scroll bar not adjusting for such which gives a less than optimal end user experienceExample.zip

  Thank you so much!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 5 October 2021, 8:23 pm EST

  Hi,

  Thanks for the sample. 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. The internal ID for this issue will SJS-10252.

  Regards
  
  Avinash

• 

  earl

  • Post Options:
  • Link
    Copy

  Posted 6 January 2022, 7:59 pm EST

  Good day,

  Any feedback on this matter as yet?

  Regards,
  
  Earl

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 12 January 2022, 3:08 pm EST

  Hi Earl,

  The dev team is actively working on fixing this issue. We are sorry but we do not have an ETA for the same. I’ll update here as soon as the issue gets fixed.

  Regards

• 

  ernie

  • Post Options:
  • Link
    Copy

  Posted 5 June 2023, 10:26 am EST

  It looks like it’s been 16 months since any activity on this topic. Have there been any improvements/adjustments to performance on larger spreadsheets?
  
  Thanks
  
  EB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 5 June 2023, 5:38 pm EST

  Hi,

  The team is working on this and it will be fixed in our future release but we don’t have any ETA for now.

  regards,
  
  Avinash

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 16 August 2023, 4:36 pm EST

  Hi,

  The mentioned issue has been resolved in the latest version of SpreadJS V16.2.0. Now after importing, scrolling and expanding/collapsing outline could give a better response than previous version. Kindly upgrade to the latest version of SpreadJS.

  You may download the latest version using the following link: http://cdn.grapecity.com/spreadjs/16.2.0/Files/SpreadJS.Release.16.2.0.zip

  Please let us know if you still face any issues.

  Regards,

  Ankit