Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / IIterationSupport Interface / MaximumChange Property
Example


In This Topic
    MaximumChange Property (IIterationSupport)
    In This Topic
    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