Class ExcelCalculationOption

Namespace

OfficeOpenXml.FormulaParsing

Assembly

EPPlus.dll

Options used by the formula parser

public class ExcelCalculationOption

Inheritance

object

ExcelCalculationOption

Inherited Members

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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