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

    Replied 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
  • 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