AbstractCalculationMonitorOnCircular Method

Implement this method to do business when calculating one cell and circular references being encountered

Namespace:  Aspose.Cells
Assembly:  Aspose.Cells (in Aspose.Cells.dll) Version: (20.9)
public virtual bool OnCircular(
	IEnumerator circularCellsData


Type: System.CollectionsIEnumerator
IEnumerator to enumerate cells(represented by CalculationCell object) in the circular chain

Return Value

Type: Boolean
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 in circular as Calculated. At the meantime, user may set the expected value as calculated result for the cell in this implementation.
To process circular references, please make sure the value of property WorkbookSettings.Iteration is true and WorkbookSettings.MaxIteration is greater than 0.
See Also