On Tue, 31 Jan 2017, Cem Dayanik (Ibtech-Software Infrastructure) wrote:
While I searched quite a lot in net, I havent able to find an exact
solution.
I havent able to write a number with 16 digits.
Ex) 3340005973272861
That's an excel limitation, or rather a limitation in the various Excel
file formats. See
https://support.microsoft.com/en-in/help/269370/last-digits-are-changed-to-zeroes-when-you-type-long-numbers-in-cells-of-excel
Is there a solution other than writing it as a string?
As per the above Microsoft support article, if you want to keep using the
XLS or XLSX file formats, a string is your only option. Other file formats
avoid this limitation, though if Excel reads those files back in it'll
often do the same truncating on them when loaded...
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
