Spread Windows Forms 12.0 Product Documentation
Iteration Property (SheetView)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : Iteration Property
Gets or sets whether circular references are evaluated on this sheet.
Public Property Iteration As Boolean
Dim instance As SheetView
Dim value As Boolean
instance.Iteration = value
value = instance.Iteration
public bool Iteration {get; set;}

Property Value

Boolean: true if circular references are evaluated; false otherwise
This example sets the maximum amount of change below which iterations stop when circular references are evaluated.
fpSpread1.ActiveSheet.Iteration = true;
fpSpread1.ActiveSheet.SetValue(0, 1, 20);
fpSpread1.ActiveSheet.MaximumChange = 5;
fpSpread1.ActiveSheet.MaximumIterations = 5;
fpSpread1.ActiveSheet.SetFormula(0, 2, "A1*3");
fpSpread1.ActiveSheet.SetFormula(0, 0, "B1+C1");
FpSpread1.ActiveSheet.Iteration = True
FpSpread1.ActiveSheet.SetValue(0, 1, 20)
FpSpread1.ActiveSheet.MaximumChange = 5
FpSpread1.ActiveSheet.MaximumIterations = 5
FpSpread1.ActiveSheet.SetFormula(0, 0, "B1+C1")
FpSpread1.ActiveSheet.SetFormula(0, 2, "A1*3")
See Also


SheetView Class
SheetView Members
MaximumChange Property
MaximumIterations Property

User-Task Documentation

Managing Formulas in Cells