For Cells.Java did you change how rounding up/down numbers is done?

Aspose.Cells Product Family
1

We upgraded Cells.Java from 18.3.9 to 22.7 and found that how numbers were rounding on parsing changed?

I attached “Book2.xlsx” which has three rows:

1.26
0.99999999999999989
1.210086921017403

the first and 3rd parse to 1 while the 2nd parses to zero in the latest version of code. Previous these would have all be parsed to 1.

2

@matthalls,
Please provide your Book2.xlsx and your code so we can look into the issue. Thank you.

3

We found it was fixed in 22.8! So I think it was fixed by this bug

CELLSJAVA-44798 Bug of formatting 0.9999999999999999 with custom “#” for JDK8 or later versions

We retested with that build and it fixed the problem

4

@matthalls,

Good to know that your issue is sorted out in newer versions. Feel free to write us back if you have further comments or queries, we will be happy to assist you soon.