Gets or sets whether circular references are evaluated.
Syntax
| Visual Basic (Declaration) | |
|---|
Property Iteration As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As IIterationSupport
Dim value As Boolean
instance.Iteration = value
value = instance.Iteration |
| C# | |
|---|
bool Iteration {get; set;} |
Property Value
true to iterate on circular references;
false otherwise
Remarks
Example
| C# | Copy Code |
|---|
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 | Copy Code |
|---|
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
See Also
