Thank you.
-----Original Message----- From: Nick Burch [mailto:apa...@gagravarr.org] Sent: Tuesday, January 31, 2017 9:18 AM To: POI Users List <user@poi.apache.org> Subject: Re: xssf writing large numbers 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 Bu e-posta'nin i?erdigi bilgiler (ekleri dahil olmak ?zere) gizlidir. Onayimiz olmaksizin ???nc? kisilere a?iklanamaz. Bu mesajin g?nderilmek istendigi kisi degilseniz, l?tfen mesaji sisteminizden derhal siliniz. IBTech A.S. bu mesajin i?erdigi bilgilerin dogrulugu veya eksiksiz oldugu konusunda bir garanti vermemektedir. Bu nedenle bilgilerin ne sekilde olursa olsun i?eriginden, iletilmesinden, alinmasindan, saklanmasindan sorumlu degildir. Bu mesajin i?erigi yazarina ait olup, IBTech A.S.'nin g?r?slerini i?ermeyebilir. The information contained in this e-mail (including any attachments)is confidential. It must not be disclosed to any person without our authority. If you are not the intended recipient, please delete it from your system immediately. IBTech A.S. makes no warranty as to the accuracy or completeness of any information contained in this message and hereby excludes any liability of any kind for the information contained therein or for the information transmission, reception, storage or use of such in any way whatsoever. Any opinions expressed in this message are those of the author and may not necessarily reflect the opinions of IBTech A.S. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
