Gets or sets the maximum amount of change below which iterations stop when circular references are evaluated on this sheet.
Syntax
Visual Basic (Declaration) | |
---|
Public Property MaximumChange As Double |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As SheetView
Dim value As Double
instance.MaximumChange = value
value = instance.MaximumChange |
C# | |
---|
public double MaximumChange {get; set;} |
Property Value
Double-precision, floating-point number representing the maximum amount of change
Example
This example sets the maximum amount of change below which iterations stop when circular references are evaluated.
C# | Copy Code |
---|
fpSpread1.ActiveSheet.Iteration = true;
fpSpread1.ActiveSheet.SetValue(0, 1, 20);
fpSpread1.ActiveSheet.MaximumChange = 5;
fpSpread1.ActiveSheet.MaximumIterations = 5;
fpSpread1.ActiveSheet.SetFormula(0, 2, "A1*3");
fpSpread1.ActiveSheet.SetFormula(0, 0, "B1+C1"); |
Visual Basic | Copy Code |
---|
FpSpread1.ActiveSheet.Iteration = True
FpSpread1.ActiveSheet.SetValue(0, 1, 20)
FpSpread1.ActiveSheet.MaximumChange = 5
FpSpread1.ActiveSheet.MaximumIterations = 5
FpSpread1.ActiveSheet.SetFormula(0, 0, "B1+C1")
FpSpread1.ActiveSheet.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