hi Aspose.cells support,

Hi,

1.

Hi,

Hi,

Thanks for your posting and using Aspose.Cells for .NET.

FYI: In Excel, there are two types of non built-in functions: Macro and Addin. We could not know which type is an unknown function.

So we added Cell.SetAddInFormula method and CellsHelper.AddAddInFunction() to set addin function.

As you can directly enter an AddIn by just typing it like a normal Excel formula in Excel, you do not need to call Cell.SetAddInFormula method.

Please call CellsHelper.AddAddInFunction() to initialize all your addin functions before construct the workbook instance.

Please see the following code.**C#**

CellsHelper. AddAddInFunction(FUNCTION1,…);

Workbook workbook = new Workbook();

Worksheet ws = workbook.Worksheets[0];

ws.Cells[“A1”].Formula = “=FUNCTION1(A2)”

The issues you have found earlier (filed as ) have been fixed in this update. This message was posted using BugNotificationTool from Downloads module by MuzammilKhan