Recalculate(Boolean) Method

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

Syntax

'Declaration
 
Public Overloads Sub Recalculate( _
   ByVal forceRecalculateAll As Boolean _
)

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

public void Recalculate( 
   bool forceRecalculateAll
)

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);

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