SpreadJS set Format for 1000 Cells slow

SpreadJS set Format for 1000 Cells slow

Posted by: martin.mayr on 21 March 2019, 3:47 am EST

• 

  martin.mayr

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 March 2019, 3:47 am EST - Updated 3 October 2022, 10:56 am EST

  we need to set the format for e.g. 1000 Cells via Code, this takes long, 50sec.

  Steps to reproduce behaviour:

  open https://www.grapecity.com/en/demos/spread/JS/InspectorSample/
  
  new sheet
  
  fill 10 columns and 100 rows with numbers
  
  select the 1000 cells

  Hit the Button Cell-Format-Increase Decimal
  
  ->Browser is blocked for 78sec
  
  

  

  972×1856 402 KB

  Is there a faster way to achieve this?

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 22 March 2019, 1:13 am EST

  Hello,

  We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix.

  Tracking id for your issue is #270927

  We will update you as soon as we hear anything from our concerned team.

  Thanks,
  
  Reeva

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 28 March 2019, 11:40 pm EST

  Hello,

  Your bug has been fixed in the latest biweekly release of SpreadJS version 12.0.10. Please download the same from this link:-
  
  http://cdn.grapecity.com/spreadjs/12.0.10/Files/SpreadJS.Release.12.0.10.zip

  Hope it helps.

  Thanks,
  
  Reeva