Spread for ASP.NET 11 Product Documentation
MaximumChange Property (IIterationSupport)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IIterationSupport Interface : MaximumChange Property
Gets or sets the maximum amount of change below which iterations stop.
Syntax
'Declaration
 
Property MaximumChange As Double
'Usage
 
Dim instance As IIterationSupport
Dim value As Double
 
instance.MaximumChange = value
 
value = instance.MaximumChange
double MaximumChange {get; set;}

Property Value

Double-precision, floating point value for the maximum amount of change
Remarks
This is the limit for calculating 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");
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")
See Also

Reference

IIterationSupport Interface
IIterationSupport Members