Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / ICalculationSupport Interface / Recalculate Method
Example


In This Topic
    Recalculate Method (ICalculationSupport)
    In This Topic
    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
    See Also