Performance issue with conditions on Designer

Performance issue with conditions on Designer

Posted by: kmalyi on 22 April 2021, 11:59 pm EST

• 

  kmalyi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 22 April 2021, 11:59 pm EST

  Hello, we are using SpreadJS and Designer, both this components has a performance issue with Conditional formatting, here is my ssjson file https://drive.google.com/file/d/1wXW8SCAKFTgPY_SCBiQ5v3iJdTP8Khjo/view?usp=sharing exported from Designer. Can you please check why it works slow and provide any suggestions how to fix that? Conditional formatting is very important for our business. Thank You!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2021, 8:55 pm EST

  Hi,

  This is expected because once set ISBLANK(K1:Q200), it will travel this range in each cell, which means, the ISBLANK will be evaluated 1200*1200 times.

  So, just change the conditional formula ISBLANK(K1), then the conditional format will adjust the base column, baseRow to each cell in the condition range.

  Regards,
  
  Avinash

• 

  kmalyi

  • Post Options:
  • Link
    Copy

  Posted 26 April 2021, 7:50 pm EST

  It helps, thank you!