IterativeCalculationsEnabled Property

Gets or sets the value which indicates whether iterations are allowed while calculating formulas containing circular references.

Syntax

C#

public bool IterativeCalculationsEnabled {get; set;}

Property Value

The value which indicates whether iterations are allowed while calculating recursive formulas.

Remarks

When iterative calculations are enabled, a formula is allowed to use circular references, or directly or indirectly reference the cell to which it belongs. Microsoft Excel stops iteratively calculating formulas after iterating MaxRecursionIterations times or when all formula values change by less than MaxChangeInIteration between two iterations.

When iterative calculations are disabled, circular references are not allowed, and a formula which references the cell to which it belongs, directly or indirectly, will cause Microsoft Excel to show an error message and the cell will contain a Circularity error.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+