Version

CalculationMode Property

Gets or sets the value which indicates how a formula will be recalculated when a referenced value changes.
Syntax
'Declaration
 
Public Property CalculationMode As CalculationMode
public CalculationMode CalculationMode {get; set;}

Property Value

The value which indicates how a formula will be recalculated when a referenced value changes.
Exceptions
ExceptionDescription
System.ComponentModel.InvalidEnumArgumentExceptionThe assigned value is not defined in the CalculationMode enumeration.
Remarks

If this is set to a value of Manual, the RecalculateBeforeSave property will determine if formulas are recalculated just before saving the file. Otherwise, that property is ignored.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also