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