RecalculateAll Method (SheetView)

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

Syntax

Visual Basic
C#

'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();
}

Visual Basic

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 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
Recalculate Method

User-Task Documentation

Recalculating Formulas