new CalculationOptions()

Methods

getCalcStackSize()

Specifies the stack size for calculating cells recursively. When there are large amount of cells need to be calculated recursively in the dependency tree, StackOverflowException may be caused in the calculation process. If so, user should specify smaller value for this property. For such situation, user should determine the proper value for this property according to the actual formulas and data. Too small value may cause performance degradation for the formula calculation.

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. When there are large amount of cells need to be calculated recursively in the dependency tree, StackOverflowException may be caused in the calculation process. If so, user should specify smaller value for this property. For such situation, user should determine the proper value for this property according to the actual formulas and data. Too small value may cause performance degradation for the formula calculation.

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.