Posted 16 July 2023, 11:01 pm EST - Updated 17 July 2023, 5:29 am EST
Hi Admin,
When I try to use sheet.setFormula it take a long time to paint canvas. Do you have another sollution to increase this performance when I use Formula. Because each row it has a total from current year => current year + 100 year ( by total column).
Thanks you.
I try to use
spread.suspendCalcService(true);
sheet.suspendEvent();
But it don’t make it to be faster
Best regards.
