FarPoint.Web.Spread Assembly > FarPoint.Web.Spread.Model Namespace > IIterationSupport Interface : MaximumChange Property |
'Declaration Property MaximumChange As Double
'Usage Dim instance As IIterationSupport Dim value As Double instance.MaximumChange = value value = instance.MaximumChange
double MaximumChange {get; set;}
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")
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6