Class ExcelCalculationOption

Options used by the formula parser

Inheritance

System.Object

ExcelCalculationOption

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.FormulaParsing

Assembly: EPPlus.dll

Syntax

public class ExcelCalculationOption

Constructors

ExcelCalculationOption()

Constructor

Declaration

public ExcelCalculationOption()

Properties

AllowCircularReferences

Do not throw an exception if the formula parser encounters a circular reference

Declaration

public bool AllowCircularReferences { get; set; }

Property Value

Type	Description
System.Boolean

AlwaysRefreshImageFunction

If true, EPPlus will download the images in the IMAGE function even if they exists in the package. The same URL will only be downloaded once. If false(default), EPPlus will only download images that doesn't exist in the package.

Declaration

public bool AlwaysRefreshImageFunction { get; set; }

Property Value

Type	Description
System.Boolean

CacheExpressions

Expressions in the formula calculation will be cached, to be reduced. This increases speed, if having multiple formulas using the same expressions. Caching increases memory consumption on calculate.

Declaration

public bool CacheExpressions { get; set; }

Property Value

Type	Description
System.Boolean

FollowDependencyChain

If true, EPPlus will calculate the cells in order calculating any dependent cells. Default. If false, EPPlus will calculate the cells without calculating dependent cells.

Declaration

public bool FollowDependencyChain { get; set; }

Property Value

Type	Description
System.Boolean

PrecisionAndRoundingStrategy

In some functions EPPlus will round double values to 15 significant figures before the value is handled. This is an option for Excel compatibility.

Declaration

public PrecisionAndRoundingStrategy PrecisionAndRoundingStrategy { get; set; }

Property Value

Type	Description
PrecisionAndRoundingStrategy