GrapeCity.Documents.Excel.IFormulaOptions.EnableIterativeCalculation

EnableIterativeCalculation Property

EnableIterativeCalculation

Gets or sets whether iterative calculation is enabled for formulas with circular references.

When enabled, the workbook iteratively calculates formulas that contain circular references until the maximum number of iterations or maximum error threshold is reached.

Declaration

bool EnableIterativeCalculation { get; set; }

Property EnableIterativeCalculation As Boolean

Examples

IFormulaOptions formulaOptions = workbook.Options.Formulas;
formulaOptions.EnableIterativeCalculation = true;
formulaOptions.MaximumIterations = 10;
bool enabled = formulaOptions.EnableIterativeCalculation;