Microsoft Excel currently includes functionality to perform iterative calculations when formulas contain circular references. By default further processing of circular formulas is broken after 100 iterations or once the value of the target cell changes by less than 0.01.
Current evaluation of pycel on formula with circular references does not take number of iterations or minimum value change into account during its execution. The result is an infinite cyclical execution that only breaks once the maximum recursion depth is reached.
Would there be any way to add this functionality or otherwise provide direction to proper execution state locations so that this functionality can be added via PR?
Microsoft Excel currently includes functionality to perform iterative calculations when formulas contain circular references. By default further processing of circular formulas is broken after 100 iterations or once the value of the target cell changes by less than 0.01.
Current evaluation of pycel on formula with circular references does not take number of iterations or minimum value change into account during its execution. The result is an infinite cyclical execution that only breaks once the maximum recursion depth is reached.
Would there be any way to add this functionality or otherwise provide direction to proper execution state locations so that this functionality can be added via PR?
Thanks for the incredible library!