AbstractCalculationEngine class

Represents user’s custom calculation engine to extend the default calculation engine of Aspose.Cells.

The AbstractCalculationEngine type exposes the following members:

Properties

Property	Description
is_param_literal_required	Indicates whether this engine needs the literal text of parameter while doing calculation. Default value is false.
is_param_array_mode_required	Indicates whether this engine needs the parameter to be calculated in array mode. Default value is false. If `CalculationData.get_param_value_in_array_mode` is required when calculating custom functions and user has not updated the definition for them (by `Workbook.update_custom_function_definition`), this property needs to be set as true.
process_built_in_functions	Whether built-in functions that have been supported by the built-in engine should be checked and processed by this implementation. Default is false.

Methods

Method	Description
calculate	Calculates one function with given data.

Remarks

User should not modify any part of the Workbook directly in this implementation(except the calculated result of the custom function, which can be set by CalculationData.CalculatedValue property). Otherwise unexpected result or Exception may be caused. If user needs to change other data than calculated result in the implementation for some custom functions, for example, change cell’s formula, style, …etc., user should gather those data in this implementation and change them out of the scope of formula calculation.

AbstractCalculationEngine class