CalculationOptions class

CalculationOptions class

Represents options for calculation.

The CalculationOptions type exposes the following members:

Constructors

ConstructorDescription
initConstructs a new instance of CalculationOptions

Properties

PropertyDescription
ignore_errorIndicates whether errors encountered while calculating formulas should be ignored.
The error may be unsupported function, external links, etc.
The default value is true.
recursiveIndicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells.
The default value is true.
custom_engineThe custom formula calculation engine to extend the default calculation engine of Aspose.Cells.
calculation_monitorThe monitor for user to track the progress of formula calculation.
calc_stack_sizeThe stack size for calculating cells recursively. Default value is 200.
precision_strategySpecifies the strategy for processing precision of calculation.
linked_data_sourcesSpecifies the data sources for external links used in formulas.
character_encodingSpecifies the encoding used for encoding/decoding characters when calculating formulas.
For functions such as CHAR, CODE, the calculated result depends on the region settings and default charset of the environment.
With this property user can specify the proper encoding used for those function to get the expected result.

See Also