I'm using version 126.96.36.199 of Aspose.Cells in Visual Basic .NET, and I'm having trouble returning a value from my CalculateCustomFunction function.
I'm assuming that I can return a boolean, integer, double, string, etc. as the Java documentation states, but when I include an empty CalculateCustomFunction function that simply returns a value (for example, 5) and use "=CUSTFUNC(1)+1" in my workbook, it has no effect. It should change it to 6, correct? Or am I misunderstanding?
When stepping through the code, I can see that CalculateCustomFunction is being called with functionName = "CUSTFUNC", it's just that I'm not sure what to return.