Performance issue while setting cell formula with SpreadJs 10/11

Performance issue while setting cell formula with SpreadJs 10/11

Posted by: saurabh.kaushal on 22 August 2018, 8:26 pm EST

• 

  saurabh.kaushal

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 August 2018, 8:26 pm 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

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 23 August 2018, 8:20 pm EST

  Hi Saurabh,

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

  Thanks,
  
  Deepak Sharma

• 

  saurabh.kaushal

  • Post Options:
  • Link
    Copy

  Posted 23 August 2018, 9:21 pm 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

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 26 August 2018, 4:16 pm EST

  Hi Saurabh,

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

  Thanks,
  
  Deepak Sharma