Custom Excel Functions

Aspose.Cells Product Family
1

Hello,

I downloaded the latest version of Aspose.Cells for .Net and have come across an issue. I was currently using v5.1.4 at this point everthing was working correctly. The issue that I am now experiencing is that the some custom functions in Excel that some cells are using are not getting updated after saving. I saw a similar issue with Excel's built in functions such as cell/range calculations. However, those were resolved when I used the CalculateFormula function in the Aspose.Cells.Workbook class. However, it did not update the custom functions.

Please advise.

2

Hi,

Please give it a try with our hot fix version Aspose.Cells5.3.1.7. If the problem persists, then attach your source code and Input file (if any). We will look into it.

Thank you for choosing Aspose
3

I tried version 5.3.1.7 and I got the same results as version 5.3.1. If I revert to version 5.3.0 all calculations within the workbook are updated whether they are build it or custom.

4

Hi,

Thanks for your posting.

Please refer to this document: Using ICustomFunction feature

If the problem still exists, then provide us your source code and input/template xls/xlsx files. We will look into them.

Make sure, you are using the latest Aspose.Cells for .NET v5.3.1.7.