UseExcelFormulaCompatibility Property

Determines if formula calculations are done in a way that is compatible with Microsoft Excel.

Syntax

Visual Basic

'Declaration
 
Public Shared Property UseExcelFormulaCompatibility As Boolean

C#

public static bool UseExcelFormulaCompatibility {get; set;}

Remarks

Set this property to true to make the CalcManager perform calculations in a way that is compatible with Microsoft Excel. By default, CalcManager calculations are performed using DotNet standards and functions. Setting this property to true will make the CalcManager's results closer to those in Excel.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, 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