Class CalculationOptionsImpl

Worksheet calculation options block.

Inheritance
System.Object
CommonObject
CalculationOptionsImpl
Implements
System.IDisposable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.ToString()
Namespace: Syncfusion.XlsIO.Implementation
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public class CalculationOptionsImpl : CommonObject, IDisposable, ICalculationOptions, IParentApplication, ICloneParent

Constructors

CalculationOptionsImpl(IApplication, Object)

Initializes new instance and sets application and parent fields.

Declaration
public CalculationOptionsImpl(IApplication application, object parent)
Parameters
Type Name Description
IApplication application

Application object for the page setup.
System.Object parent

Parent object for the page setup.

CalculationOptionsImpl(IApplication, Object, BiffRecordRaw[], Int32)

Recovers Page setup from the Biff Records array starting from position

Declaration
[CLSCompliant(false)]
public CalculationOptionsImpl(IApplication application, object parent, BiffRecordRaw[] data, int iPos)
Parameters
Type Name Description
IApplication application

Application object for the page setup.
System.Object parent

Parent object for the page setup.
Syncfusion.XlsIO.Parser.Biff_Records.BiffRecordRaw[] data

Array of Biff Records that contains all needed records.
System.Int32 iPos

Position of PrintHeadersRecord in the array.

Fields

DEF_CORRECT_CODES

Correct records.

Declaration
public static TBIFFRecord[] DEF_CORRECT_CODES
Field Value
Type
TBIFFRecord[]

Properties

CalculationMode

Specifies the mode of formula value calculations.

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

IsIterationEnabled

Indicates whether iterations are turned on.

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

MaximumChange

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

Declaration
public 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
public int MaximumIteration { get; set; }
Property Value
Type
System.Int32

R1C1ReferenceMode

Indicates whether R1C1 reference mode is turned on.

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

RecalcOnSave

Defines whether to recalculate before saving.

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

Methods

Clone(Object)

Creates a new object that is a copy of the current instance.

Declaration
public object Clone(object parent)
Parameters
Type Name Description
System.Object parent

Parent object for a copy of this instance.
Returns
Type Description
System.Object

A new object that is a copy of this instance.

Parse(IList, Int32)

Recovers Page setup from the Biff Records array starting from the position specified.

Declaration
public int Parse(IList data, int iPos)
Parameters
Type Name Description
System.Collections.IList data

Biff Records data.
System.Int32 iPos

Position of first PageSetup record - PrintHeadersRecord.
Returns
Type Description
System.Int32

Position after extracting calculation options.

Serialize(OffsetArrayList)

Adds all records to OffsetArrayList.

Declaration
[CLSCompliant(false)]
public void Serialize(OffsetArrayList records)
Parameters
Type Name Description
OffsetArrayList records

OffsetArrayList which will get all records.

Implements

System.IDisposable