Spread for ASP.NET 7.0 Product Documentation
RecalculateAll Method
See Also  Example Support Options
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : RecalculateAll Method


Glossary Item Box

Evaluates all the formulas in the sheet (including those that have not changed since the last calculation cycle).

Syntax

Visual Basic (Declaration) 
Public Sub RecalculateAll() 
Visual Basic (Usage)Copy Code
Dim instance As SheetView
 
instance.RecalculateAll()
C# 
public void RecalculateAll()

Example

This example evaluates all the formulas in the sheet since the last calculation cycle.
C#Copy Code
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();
}
Visual BasicCopy Code
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

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.