Posted 22 April 2021, 11:59 pm ESTHello, 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!
Performance issue with conditions on Designer
Posted by: kmalyi on 22 April 2021, 11:59 pm EST
Marked as Answer
Replied 25 April 2021, 8:55 pm ESTHi,
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 ESTIt helps, thank you!