Cell that use an add-in function has no formula

Aspose.Cells Product Family
1

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.

2

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.

3

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);

4

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.