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, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List