Spread for ASP.NET 8.0 Product Documentation
Recalculate Method (ICalculationSupport)
Example 


Evaluates the formulas in the sheet that have changed since the last calculation cycle.
Syntax
'Declaration
 
Sub Recalculate() 
'Usage
 
Dim instance As ICalculationSupport
 
instance.Recalculate()
void Recalculate()
Example
FarPoint.Web.Spread.Model.ICalculationSupport cs; 
FpSpread1.ActiveSheetView.SetValue(0, 0, 20); 
FpSpread1.ActiveSheetView.SetValue(0, 1, 10); 
FpSpread1.ActiveSheetView.SetFormula(3, 0, "SUM(A1,B1)"); 

FpSpread1.ActiveSheetView.AutoCalculation = false; 
FpSpread1.ActiveSheetView.SetValue(0, 1, 100); 
cs = (FarPoint.Web.Spread.Model.ICalculationSupport)FpSpread1.ActiveSheetView.DataModel; 
cs.Recalculate(); 
Dim cs As FarPoint.Web.Spread.Model.ICalculationSupport
FpSpread1.ActiveSheetView.SetValue(0, 0, 20)
FpSpread1.ActiveSheetView.SetValue(0, 1, 10)
FpSpread1.ActiveSheetView.SetFormula(2, 0, "SUM(A1,B1)")

Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    Dim cs As FarPoint.Web.Spread.Model.ICalculationSupport
    FpSpread1.ActiveSheetView.AutoCalculation = False
    FpSpread1.ActiveSheetView.SetValue(0, 1, 100)
    cs = FpSpread1.ActiveSheetView.DataModel
    cs.Recalculate()
End Sub
Requirements

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

See Also

Reference

ICalculationSupport Interface
ICalculationSupport Members

 

 


Copyright © GrapeCity, inc. All rights reserved.