We are facing a formula issue in Java Aspose Cells 8.6.2. Result produced by the Excel sheet and Aspose is different.
Actual Result produced by Excel sheet for Cell D1 and E1 is #NUM!, but the Aspose produces the result as -1.0 which is causing issue in our application.
Please find the attached sample excel sheet. Read the following cells after applying workbook.calculateFormula().
Sheet Name = Sheet1
Cell Name = Cell D1 and E1
Please do the needful.
Thank you for the sample spreadsheet.
We are able to replicate the said problem on our side therefore we have logged it in our bug tracking system as CELLSJAVA-41601 for further analysis. Our product team will further look into the details of this problem and we will keep you updated on the status of correction. We apologize for your inconvenience.
This is to update you that we have fixed the problem logged earlier as CELLSJAVA-41601. We will shortly provide the fix here after ensuring the quality and incorporating other enhancements.
Thanks for using Aspose.Cells.
Please download and try the latest fix: Aspose.Cells for Java v18.104.22.168 and let us know your feedback.