Free Support Forum - aspose.com

Cell that use an add-in function has no formula

In the attach designer the cell B22 use and add-in function.
I wrote an ICustomFunction class to handle the call to the function.
But the engine never transfer the execution to my icustom.

I've notice that I've : cells["B22"].formula =null
Maybe, as the formula is null, the engine do not transfer execution to my icustom.

Hi,

Thanks for considering Aspose.

How do you implement ICustomFunction, Could you give us your complete sample code here. We will check it soon.

Thank you.

Which version of Aspose.Cells are you using?

Following is a simple sample to pass your implementation for custom functions:

public class CustomFunction : Aspose.Cells.ICustomFunction
{
public object CalculateCustomFunction(string functionName, ArrayList paramsList, ArrayList contextObjects)
{

......

}

}

Workbook wb = new Workbook();

wb.Open("d:\\test\\designer.xls");

CustomFunction customFunction = new CustomFunction();
wb.CalculateFormula(false, customFunction);

With all your pointers,
I discover that I was not using latest version of Aspose.Cells and that my implementation of ICustom as some flow.

Now, I upgrade and correct implementation.

Everything is working super.

Thanks for your help.