new CalculationOptions()

Methods

getCalcStackSize()

Specifies the stack size for calculating cells recursively. -1 for this property means the calculation will use WorkbookSettings.CalcStackSize of corresponding workbook. WorkbookSettings.CalcStackSize

getCalculationMonitor()

The monitor for user to track the progress of formula calculation.

getIgnoreError()

Indicates if you need to hide the error in calculating formulas. The error may be unsupported function, external links, etc.

getPrecisionStrategy()

Specifies the strategy for processing precision of calculation. The value of the property is CalculationPrecisionStrategy integer constant.

getRecursive()

Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells.

setCalcStackSize()

Specifies the stack size for calculating cells recursively. -1 for this property means the calculation will use WorkbookSettings.CalcStackSize of corresponding workbook. WorkbookSettings.CalcStackSize

setCalculationMonitor()

The monitor for user to track the progress of formula calculation.

setIgnoreError()

Indicates if you need to hide the error in calculating formulas. The error may be unsupported function, external links, etc.

setPrecisionStrategy()

Specifies the strategy for processing precision of calculation. The value of the property is CalculationPrecisionStrategy integer constant.

setRecursive()

Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells.