Recalculate(Boolean) 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( _
   ByVal forceRecalculateAll As System.Boolean _
)

'Usage
 
Dim instance As Worksheet
Dim forceRecalculateAll As System.Boolean
 
instance.Recalculate(forceRecalculateAll)

public void Recalculate( 
   System.bool forceRecalculateAll
)

Parameters

forceRecalculateAll: Whether to force recalculation of all formulas in the current manager.

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