Hi,
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.