MaximumIterations Property (DefaultSheetDataModel)

Gets or sets the maximum number of iterations for calculations with circular references.

Syntax

Visual Basic
C#

'Declaration
 
Public Property MaximumIterations As Integer

'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Integer
 
instance.MaximumIterations = value
 
value = instance.MaximumIterations

public int MaximumIterations {get; set;}

Property Value

Integer number of iterations

Exceptions

Exception	Description
System.ArgumentOutOfRangeException	Specified number of iterations is out of range; must be an integer between 1 and 32767

Example

This example specifies the maximum amount of change below which iterations (of recalculation) stop.

Visual Basic

Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetValue(0, 0, 20)
dataModel.SetValue(0, 1, 10)
dataModel.SetValue(0, 2, 10)
dataModel.Iteration = True
dataModel.MaximumIterations = 3
dataModel.MaximumChange = 600
dataModel.SetFormula(0, 0, "B1+C1")
dataModel.SetFormula(0, 2, "A1*3")

FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetValue(0, 0, 20);
dataModel.SetValue(0, 1, 10);
dataModel.SetValue(0, 2, 10);
dataModel.Iteration = true;
dataModel.MaximumIterations = 3;
dataModel.MaximumChange = 600;
dataModel.SetFormula(0, 0, "B1+C1");
dataModel.SetFormula(0, 2, "A1*3");

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members