Class CalculationOptions

CalculationOptions class

Represents options for calculation.

public class CalculationOptions

Constructors

NameDescription
CalculationOptions()The default constructor.

Properties

NameDescription
CalcStackSize { get; set; }The stack size for calculating cells recursively. Default value is 200.
CalculationMonitor { get; set; }The monitor for user to track the progress of formula calculation.
CharacterEncoding { get; set; }Specifies 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.
CustomEngine { get; set; }The custom formula calculation engine to extend the default calculation engine of Aspose.Cells.
IgnoreError { get; set; }Indicates whether errors encountered while calculating formulas should be ignored. The error may be unsupported function, external links, etc. The default value is true.
LinkedDataSources { get; set; }Specifies the data sources for external links used in formulas.
PrecisionStrategy { get; set; }Specifies the strategy for processing precision of calculation.
Recursive { get; set; }Indicates whether calculate the dependent cells recursively when calculating one cell and it depends on other cells. The default value is true.

See Also