Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / Recalculate Method
Example


In This Topic
    Recalculate Method (SheetView)
    In This Topic
    Evaluates all the formulas in the sheet that have changed since the last calculation cycle.
    Syntax
    'Declaration
     
    Public Sub Recalculate() 
    'Usage
     
    Dim instance As SheetView
     
    instance.Recalculate()
    public void Recalculate()
    Example
    This example evaluates all the formulas in the sheet that have changed since the last calculation cycle.
    private void PageLoad(object sender, System.EventArgs e)
    {
          FarPoint.Web.Spread.SheetView sv;
          sv = FpSpread1.ActiveSheetView;
          sv.Cells[0, 0, 2, 3].CellType = New FarPoint.Web.Spread.IntegerCellType();
          sv.SetValue(0, 0, 20)
          sv.SetValue(1, 0, 10)
          sv.SetFormula(2, 0, "Sum(A1,A2)");
          sv.AutoCalculation = false;
    }
    
    private void Button1Click(object sender, System.EventArgs e)
    {
          FarPoint.Web.Spread.SheetView sv;
          sv = FpSpread1.ActiveSheetView;
          sv.Cells[1, 0].Value = 100;
          sv.Recalculate();
    }
    
    Private Sub PageLoad(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
          Dim sv As FarPoint.Web.Spread.SheetView
          sv = FpSpread1.ActiveSheetView
          sv.Cells(0, 0, 2, 3).CellType = New FarPoint.Web.Spread.IntegerCellType
          sv.SetValue(0, 0, 20)
          sv.SetValue(1, 0, 10)
          sv.SetFormula(2, 0, "Sum(A1,A2)")
          sv.AutoCalculation = False
    End Sub
    
    Private Sub Button1Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
          Dim sv As FarPoint.Web.Spread.SheetView
          sv = FpSpread1.ActiveSheetView
          sv.Cells(1, 0).Value = 100
          sv.Recalculate()
    End Sub
    See Also