How would you determine the progress of a ultra grid being calculated?
Say I have a grid that has many columns with formlas,
I would like to show a progress bar for the rows or columns finished being calculated.
I would also like to know if there is a way to query all formulas / objects that have dirty formulas.
The calc manager takes a while to caculate my grid (if there was a way to also speed it up, that would be good) and I need to give my user a notification.
Thanks.
Hi Frank,
I don't believe there is any way to do this. The CalcManager has an event for when it is finished, but there is no way to know how many formulas there are in total or how many have been or have not been calculated. In fact, since the calculations are asynchronous and formulas may be dependent on other formulas, I don't think it's possible to know this ahead of time.