When I open the Excel sheet there is a value in the cell, but it is incorrectly calculated. When I "edit" it and hit CTRL + SHIFT + ENTER myself, the value is then correct. I was using Aspose.Cells 4.5.0.0, but I came across 4.5.0.13 on the forums but the problem is still there.
I have attached a copy of my problem from my original test. The value at the bottom should equal -4.8%.
Have you had any luck fixing this issue? I have a prototype of the the report that my client needs, but the Array Function issue is preventing me from sending it on to them and having them purchase the component for use in their application.
This causes #VALUE, but when I hit CTRL + SHIFT + ENTER myself, the value is correct
I've tried other things like testing is the denominator of the division is 0 (e.g. IF (SUM(...) = 0) prior to calling the formula, this works in Excel, but not with Aspose. In this case I get an error message when opening the workbook and {#N/A} is shown in the field.
Is there another way for me to test this and prevent the DIV/0 errors that will work with Aspose.Cells?
I tried the version in that post, but the problem still persists. I have attach a spreadsheet with the problem. The first group in the spreadsheet is a subset of what was generated with Aspose.Cells, and the second group is when I make it an array function myself in Excel.