Iteration Property (IIterationSupport)

Gets or sets whether circular references are evaluated.

Syntax

Visual Basic
C#

'Declaration
 
Property Iteration As Boolean

'Usage
 
Dim instance As IIterationSupport
Dim value As Boolean
 
instance.Iteration = value
 
value = instance.Iteration

bool Iteration {get; set;}

Property Value

true to iterate on circular references; false otherwise

Remarks

This is whether to calculate values that have a circular reference in the formula.

Example

FarPoint.Web.Spread.Model.IIterationSupport iis; 
iis = (FarPoint.Web.Spread.Model.IIterationSupport)FpSpread1.ActiveSheetView.DataModel; 
iis.Iteration = true; 
iis.MaximumChange = 5; 
iis.MaximumIterations = 3; 
FpSpread1.ActiveSheetView.SetValue(0, 0, 10); 
FpSpread1.ActiveSheetView.SetValue(0, 1, 20); 
FpSpread1.ActiveSheetView.SetValue(0, 2, 30); 
FpSpread1.ActiveSheetView.SetFormula(0, 2, "B1+C1"); 
FpSpread1.ActiveSheetView.SetFormula(0, 0, "A1*C1");

Visual Basic

Dim iis As FarPoint.Web.Spread.Model.IIterationSupport
iis = FpSpread1.ActiveSheetView.DataModel
iis.Iteration = True
iis.MaximumChange = 5
iis.MaximumIterations = 3
FpSpread1.ActiveSheetView.SetValue(0, 0, 10)
FpSpread1.ActiveSheetView.SetValue(0, 1, 20)
FpSpread1.ActiveSheetView.SetValue(0, 2, 30)
FpSpread1.ActiveSheetView.SetFormula(0, 2, "B1+C1")
FpSpread1.ActiveSheetView.SetFormula(0, 0, "A1*C1")

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

IIterationSupport Interface
IIterationSupport Members