Recalculate() Method

Evaluates all the cell formulas on the sheet that have changed since the last calculation cycle.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub Recalculate()

'Usage
 
Dim instance As Worksheet
 
instance.Recalculate()

public void Recalculate()

Example

This example uses the Recalculate method.

gcSpreadSheet1.Sheets[0].Recalculate();
//gcSpreadSheet1.Sheets[0].Recalculate(true);

VB.NET

GcSpreadSheet1.Sheets(0).Recalculate()
'GcSpreadSheet1.Sheets(0).Recalculate(True)

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

Worksheet Class
Worksheet Members
Overload List