Aspose.Cells' formula result does not match with Excel

Aspose.Cells Product Family
1

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 B2 is #N/A, but the Aspose produces the result as 1.04125 which is causing issue in our application.

Please find the attached sample excel sheet and sample program.

Sheet Name = Sheet1
Cell Name = B2

Please do the needful.


2

Hi Vinod,


Thank you for contacting Aspose support.

First of all, please note that we have split the existing thread to create a new one on your behalf because it is appropriate to share the distinct concerns in individual threads. Regarding your original concerns, we are able to replicate the said problem on our side therefore we have logged it under the ticket CELLSJAVA-41595 for further investigation. 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.
3

Hi,

Thanks for using Aspose.Cells.

For ms excel, numeric value 0 will be formatted as 1900-1-0 where the
day is 0. It is obviously incorrect and we cannot get any api to format
one datetime as “0” day. So we cannot give the same value with ms excel
in calculating formulas.