Interface ICalculationOptions
Represents the Calculation options in a Excel Workbook.
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public interface ICalculationOptions : IParentApplicationProperties
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 |