Interface ICalculationOptions

Represents the Calculation options in a Excel Workbook.

Inherited Members
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public interface ICalculationOptions : IParentApplication

Properties

CalculationMode

Gets/sets calculation mode in Excel.

Declaration
ExcelCalculationMode CalculationMode { get; set; }
Property Value
Type Description
ExcelCalculationMode

IsIterationEnabled

Indicates whether iterations are turned on.

Declaration
bool IsIterationEnabled { get; set; }
Property Value
Type Description
System.Boolean

MaximumChange

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

Declaration
double MaximumChange { get; set; }
Property Value
Type Description
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 Description
System.Int32

R1C1ReferenceMode

Indicates whether R1C1 reference mode is turned on.

Declaration
bool R1C1ReferenceMode { get; set; }
Property Value
Type Description
System.Boolean

RecalcOnSave

Defines whether to recalculate before saving.

Declaration
bool RecalcOnSave { get; set; }
Property Value
Type Description
System.Boolean

Extension Methods