GrapeCity.Documents.Excel.IFormulaOptions

Interface IFormulaOptions

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents the options related to formula caculation, performance, and error handing.

public interface IFormulaOptions

Properties

CalculationMode

Gets or sets the calculation mode, this setting will only affect I/O of MS Excel/SSJSON/SJS files. Setting CalculationMode as Manual will prevent MS Excel or SpreadJS from automatically calculating formulas on opening the workbook. Additionally, Manual improves the speed of opening workbooks that contain a large number of formulas in MSExcel and SpreadJS. If you want to disable the calculation for the current workbook, please use EnableCalculation.

CalculationMode CalculationMode { get; set; }

Property Value

CalculationMode

EnableIterativeCalculation

Enable iterative calculation.

bool EnableIterativeCalculation { get; set; }

Property Value

bool

MaximumChange

Maximum change for iterative calculation.

double MaximumChange { get; set; }

Property Value

double

MaximumIterations

Maximum iterations for iterative calculation.

int MaximumIterations { get; set; }

Property Value

int