Spread for ASP.NET 11 Product Documentation
RecalculateAll Method (SheetView)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : RecalculateAll Method
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

Reference

SheetView Class
SheetView Members
Recalculate Method

User-Task Documentation

Recalculating Formulas