Skip to content

Class ParsingConfiguration

Namespace: OfficeOpenXml.FormulaParsing
Assembly: EPPlus.dll

Configuration of a FormulaParser

public class ParsingConfiguration

Inheritance

object ← ParsingConfiguration

Inherited Members

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

Properties

AllowCircularReferences

Configures the formula calc engine to allow circular references.

public bool AllowCircularReferences { get; }

Property Value

bool

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 don't exist in the package.

public bool AlwaysRefreshImageFunction { get; set; }

Property Value

bool

CacheExpressions

If EPPlus will should cache expressions or not. Default is true.

public bool CacheExpressions { get; }

Property Value

bool

EnableUnicodeAwareStringOperations

Enables Unicode-aware string operations, ensuring correct handling of surrogate pairs for comparisons, substrings, and sorting within the library.

public bool EnableUnicodeAwareStringOperations { get; set; }

Property Value

bool

FunctionRepository

The FunctionRepository of the parser

public FunctionRepository FunctionRepository { get; }

Property Value

FunctionRepository

Logger

The IFormulaParserLogger of the parser

public IFormulaParserLogger Logger { get; }

Property Value

IFormulaParserLogger

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; }

Property Value

PrecisionAndRoundingStrategy

Methods

AttachLogger(IFormulaParserLogger)

Attaches a logger, errors and log entries will be written to the logger during the parsing process.

public ParsingConfiguration AttachLogger(IFormulaParserLogger logger)

Parameters

logger IFormulaParserLogger

Returns

ParsingConfiguration

DetachLogger()

if a logger is attached it will be removed.

public ParsingConfiguration DetachLogger()

Returns

ParsingConfiguration