On Sun, 20 Oct 2019, Andreas Reichel wrote:
Opening the file in an XML Text Editor, I get 0.10669129999999999.
Opening the file in GNUMERIC, I get 0.10669129999999999. (Both the
shown cell content as well as the editable text box).
Opening the file in LibreOffice, I get 0.1066913. (Same file, I have
tried 3 times. Both the shown cell content as well as the editable text
box).
Opening the file in MS Excel, I get 0.1066913.
So, while it is still an Excel problem, I wonder how/why LibreOffice
and Excel know/decide about interpreting the value as 0.1066913?!
If you ask POI to format the value to a string based on the formatting
rules applied to the cell, using DataFormatter or similar, do you get the
value you expect?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org