We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Bug in IF()

I have a very simple excel sheet, which I can upload, but it only has 3 cells.

A1                B1                            C1
2E-19             =IF(A1=0,"zero",A1)           =A1

In Excel, all 3 cells have the value 2.0E-19, as expected. In Aspose Cells Java version 18.5, B1 has the value “zero”, whilst the other 2 cells match Excel.

Is this bug fixed in a new version of the product? If it’s still happening, do you agree it’s a bug?


I could not reproduce the issue with latest version of API so could you please try it and let us know your feedback.

aspose-cells-20.8.9-java.zip (7.2 MB)

If issue occurs then share runnable code and your template file for our analysis.