Performance issue with conditions on Designer

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

  • 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 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!
  • Marked as Answer

    Replied 25 April 2021, 8:55 pm EST


    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.

  • Replied 26 April 2021, 7:50 pm EST

    It helps, thank you!
Need extra support?

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

Learn More

Forum Channels