Working with custom calculation engine

Implement Custom Calculation Engine

Aspose.Cells.GridWeb has a powerful calculation engine that can calculate almost all of the Microsoft Excel formulas. However, it also allows you to extend the default calculation engine, which provides you greater power and flexibility.

The following properties and classes are used in implementing this feature.

The following code implements the Custom Calculation Engine. It implements the interface GridAbstractCalculationEngine which has a Calculate(GridCalculationData data) method. This method is called against all of your formulas. Inside this method, we capture the MYTESTFUNC formula and multiply its first parameter value by 2.

Programming Sample