We have Aspose Cell Java version 17.9.
We noticed a bug where if you have an XLSX file with a column with numerics that have longer than 15 digits the number coming back doesn’t match what is in Excel
sample.zip (9.5 KB)
See attached file.
If you click on the cell E:2 (row 2, column RecordID) you will see in Excel the # is shown as:
saving as CSV gives you this same number.
Notice that the zeros start after the 15th digit
Formatting thinks Number, no thousands, no decimals.
Return from com.aspose.cells.Cell.getStringValue(): “3200000000487859700”
(Prior version of Aspose: “3200000000487860200”)
This is a problem for us as numbers for our customers are changing. Is there a known workaround for this or a fix possibly in a newer version?