Gets or sets the maximum amount of change below which to stop iterating for caclulations with circular references.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property MaximumChange As Double |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As DefaultSheetDataModel
Dim value As Double
instance.MaximumChange = value
value = instance.MaximumChange |
| C# | |
|---|
public double MaximumChange {get; set;} |
Property Value
Maximum amount of change
Exceptions
Example
This example specifies the maximum amount of change below which iterations (of recalculation) stop.
| Visual Basic | Copy Code |
|---|
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") |
| C# | Copy Code |
|---|
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"); |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
