Interface ICalculationOptions

Represents the Calculation options in a Excel Workbook.

Inherited Members

IParentApplication.Application

IParentApplication.Parent

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.NET.dll

Syntax

public interface ICalculationOptions : IParentApplication

Properties

CalculationMode

Gets/sets calculation mode in Excel.

Declaration

ExcelCalculationMode CalculationMode { get; set; }

Property Value

Type
ExcelCalculationMode

IsIterationEnabled

Indicates whether iterations are turned on.

Declaration

bool IsIterationEnabled { get; set; }

Property Value

Type
System.Boolean

MaximumChange

Gets / sets maximum change of the result to the exit of an iteration.

Declaration

double MaximumChange { get; set; }

Property Value

Type
System.Double

MaximumIteration

Specifies the maximum number of times the formulas should be iteratively calculated. This is a fail-safe against mutually recursive formulas locking up a spreadsheet application.

Declaration

int MaximumIteration { get; set; }

Property Value

Type
System.Int32

R1C1ReferenceMode

Indicates whether R1C1 reference mode is turned on.

Declaration

bool R1C1ReferenceMode { get; set; }

Property Value

Type
System.Boolean

RecalcOnSave

Defines whether to recalculate before saving.

Declaration

bool RecalcOnSave { get; set; }

Property Value

Type
System.Boolean