GrapeCity.Documents.Excel.IFormulaOptions.MaximumIterations

MaximumIterations Property

MaximumIterations

Gets or sets the maximum iterations of iterative calculation.

When iterative calculation is enabled, formulas are recalculated until the maximum number of iterations is reached or the maximum error threshold is met.

Declaration

int MaximumIterations { get; set; }

Property MaximumIterations As Integer

Examples

IFormulaOptions formulaOptions = workbook.Options.Formulas;
formulaOptions.EnableIterativeCalculation = true;
formulaOptions.MaximumIterations = 10;
int maximumIterations = formulaOptions.MaximumIterations;