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. Despite this, it also allows you to extend the default calculation engine which provides you greater power and flexibility.

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

• GridAbstractCalculationEngine
• GridCalculationData

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 by 2 for its first parameter value .

Programming Sample

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
private class CustomEngineSimple : GridAbstractCalculationEngine
{
    public override void Calculate(GridCalculationData data)
    {
        if (!"MYTESTFUNC".Equals(data.FunctionName.ToUpper()))
        {
            return;
        }
        data.CalculatedValue = (decimal)(2.0 * (double)data.GetParamValue(0));  
    }
}
protected void Page_Load(object sender, EventArgs e)
{
   
    // If first visit this page clear GridWeb1 and load data 
    if (!IsPostBack && !GridWeb1.IsPostBack)
    {
		  CustomEngineSimple ce = new CustomEngineSimple();
          GridWeb1.CustomCalculationEngine = ce;
          GridWorksheet sheet = GridWeb1.ActiveSheet;
          GridCell cell = sheet.Cells["A1"];
          cell.Formula = "=MYTESTFUNC(3.0)";

          cell = sheet.Cells["A2"];
          cell.PutValue("hello");

          cell = sheet.Cells["B1"];
          cell.PutValue(1);
          cell = sheet.Cells["B2"];
          cell.PutValue(2);
          cell = sheet.Cells["B3"];
          cell.PutValue(3);

          cell = sheet.Cells["A3"];
          cell.Formula = "=SUM(B1:B3)";

          GridWeb1.CalculateFormula();
          sheet.ActiveCell = "A4";
    }
}