MaximumChange Property (SheetView)

Gets or sets the maximum amount of change below which iterations stop when circular references are evaluated on this sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property MaximumChange As Double

'Usage
 
Dim instance As SheetView
Dim value As Double
 
instance.MaximumChange = value
 
value = instance.MaximumChange

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.

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

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

Reference

SheetView Class
SheetView Members
MaximumIterations Property
Iteration Property

User-Task Documentation

Managing Formulas in Cells