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


In This Topic
    RecalculateAll Method (SheetView)
    In This Topic
    Evaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle).
    Syntax
    'Declaration
     
    Public Sub RecalculateAll() 
    'Usage
     
    Dim instance As SheetView
     
    instance.RecalculateAll()
    public void RecalculateAll()
    Example
    This example evaluates all the formulas in the sheet 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.RecalculateAll();
    }
    
    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.RecalculateAll()
    End Sub
    See Also