Calculate Custom Functions in GridWeb

Possible Usage Scenarios

Aspose.Cells.GridWeb supports the calculation of custom functions with the GridWeb.CustomCalculationEngine property. This property takes an instance of the GridAbstractCalculationEngine interface. Please implement the GridAbstractCalculationEngine interface and calculate your custom functions with your own logic.

Calculate Custom Functions in GridWeb

The following sample code adds a custom function named MYTESTFUNC() in cell B3. Then we calculate the value of this function by implementing the GridAbstractCalculationEngine interface. We calculate MYTESTFUNC() in such a way that it multiplies its parameter by 2 and returns the result. So if its parameter is 9, it will return 2 * 9 = 18.

Sample Code