Class ExcelCalculationCacheSettings¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Settings for formula calculation caching and optimization

public class ExcelCalculationCacheSettings

Inheritance¶

object ← ExcelCalculationCacheSettings

Inherited Members¶

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

Constructors¶

ExcelCalculationCacheSettings()¶

public ExcelCalculationCacheSettings()

Properties¶

Default¶

Gets the default configuration for Excel calculation cache settings.

public static ExcelCalculationCacheSettings Default { get; }

Property Value¶

ExcelCalculationCacheSettings

Remarks¶

Use this property to obtain a standard set of cache settings suitable for most scenarios. The returned instance is immutable and can be shared safely across multiple components.

MaxFlattenedRanges¶

Maximum number of flattened ranges to cache for RangeCriteria functions (SUMIFS, AVERAGEIFS, COUNTIFS). Default is 100. Set to 0 to disable flattened range caching.

public int MaxFlattenedRanges { get; set; }

Property Value¶

int

MaxMatchIndexes¶

Maximum number of match indexes to cache for RangeCriteria functions (SUMIFS, AVERAGEIFS, COUNTIFS). Default is 1000. Set to 0 to disable match index caching.

public int MaxMatchIndexes { get; set; }

Property Value¶

int