Recalculate() Method

Recalculates all dirty formulas pending a calculation on the workbook.

Syntax

C#

public void Recalculate()

Remarks

This can be used when the CalculationMode is Manual. In Manual mode, when cells are dirtied, formulas referencing those cells will not be recalculated until Recalculate is called or RecalculateBeforeSave is True and the workbook is saved.

To force a recalculation of non-dirty formulas, use the Recalculate(Boolean) overload and specify True for the includeNonDirtyFormulas parameter.

Requirements

Target Platforms: Android 4.4+, iOS 8+

Development Environments: Visual Studio 2015+, Visual Studio for Mac Preview, Xamarin for Visual Studio 4.2+