Class ExcelCalculationOption¶

Namespace: OfficeOpenXml.FormulaParsing
Assembly: EPPlus.dll

Options used by the formula parser

public class ExcelCalculationOption

Inheritance¶

object ← ExcelCalculationOption

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Constructors¶

ExcelCalculationOption()¶

Constructor

public ExcelCalculationOption()

Properties¶

AllowCircularReferences¶

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

public bool AllowCircularReferences { get; set; }

Property Value¶

bool

CacheExpressions¶

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

public bool CacheExpressions { get; set; }

Property Value¶

bool

FollowDependencyChain¶

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

public bool FollowDependencyChain { get; set; }

Property Value¶

bool

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.

public PrecisionAndRoundingStrategy PrecisionAndRoundingStrategy { get; set; }

Property Value¶

PrecisionAndRoundingStrategy