Performance issue while setting cell formula with SpreadJs 10/11

Posted by: saurabh.kaushal on 23 August 2018, 5:26 am EST

  • Posted 23 August 2018, 5:26 am EST

    Hi,

    We are using spreadjs 10/11 in our project with angular2.
    We are facing performance issue while setting formula in multiple cells and rows in web (chrome, IE, firefox, IE edge), however in windows application(spread 10/11) its working perfectly fine.
    We have used Sheet.resumeCalcService(false) as well, but its still very slow.
    Please do the needful/suggest to increase the performance.

    Thanks,
    Saurabh Kaushal
  • Replied 24 August 2018, 5:20 am EST

    Hi Saurabh,

    You can use resumePaint() and suspendPaint() along suspendCalcService() and resumeCalcService() methods to improve performance.

    Thanks,
    Deepak Sharma
  • Replied 24 August 2018, 6:21 am EST

    Hi Deepak,

    Thanks for your response.

    We are already using resumePaint() and suspendPaint() along suspendCalcService(). Still performance is very low.

    We are using spreadjs v10/V11 with angular. It takes more than 1 minute in edge and hangs in internet explorer , firefox just to update cell formulas in 12 columns and below 100 rows.

    However in windows application same implementation with spread v10/V11 is working fine.

    Thanks,
    Saurabh Kaushal
  • Marked as Answer

    Replied 27 August 2018, 1:16 am EST

    Hi Saurabh,

    Could you please provide me your sample application to test further?

    Thanks,
    Deepak Sharma
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels