on_circular method

on_circular

Implement this method to do business when calculating formulas with circular references.

Returns

Whether the formula engine needs to calculate those cells in circular after this call. True to let the formula engine continue to do calculation for them. False to let the formula engine just mark those cells as Calculated.

def on_circular(self, circular_cells_data):
    ...
ParameterTypeDescription
circular_cells_datacollections.abc.IteratorIEnumerator with CalculationCell items representing cells that
depend on circular references.

Remarks

In the implementation user may also set the expected value as calculated result for part/all of those cells so the formula engine will not calculate them recursively.

See Also