Spread Windows Forms 11.0 Product Documentation
MaximumChange Property (DefaultSheetDataModel)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class : MaximumChange Property
Gets or sets the maximum amount of change below which to stop iterating for caclulations with circular references.
Syntax
'Declaration
 
Public Property MaximumChange As Double
'Usage
 
Dim instance As DefaultSheetDataModel
Dim value As Double
 
instance.MaximumChange = value
 
value = instance.MaximumChange
public double MaximumChange {get; set;}

Property Value

Maximum amount of change
Exceptions
ExceptionDescription
Specified amount is out of range; must be zero or more
Example
This example specifies the maximum amount of change below which iterations (of recalculation) stop.
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel(10, 10)
FpSpread1.ActiveSheet.Models.Data = dataModel
dataModel.SetValue(0, 0, 20)
dataModel.SetValue(0, 1, 10)
dataModel.SetValue(0, 2, 10)
dataModel.Iteration = True
dataModel.MaximumIterations = 3
dataModel.MaximumChange = 600
dataModel.SetFormula(0, 0, "B1+C1")
dataModel.SetFormula(0, 2, "A1*3")
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(8, 8);
fpSpread1.ActiveSheet.Models.Data = dataModel;
dataModel.SetValue(0, 0, 20);
dataModel.SetValue(0, 1, 10);
dataModel.SetValue(0, 2, 10);
dataModel.Iteration = true;
dataModel.MaximumIterations = 3;
dataModel.MaximumChange = 600;
dataModel.SetFormula(0, 0, "B1+C1");
dataModel.SetFormula(0, 2, "A1*3"); 
See Also

Reference

DefaultSheetDataModel Class
DefaultSheetDataModel Members