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


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")
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

Reference

IIterationSupport Interface
IIterationSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.