Guys, I am sorry: just one more for the fun. 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.
I can guarantee that the end-user has captured 0.1066913 (because its a nominal interest rate, nobody would negotiate or type 0.10669129999999999). So, while it is still an Excel problem, I wonder how/why LibreOffice and Excel know/decide about interpreting the value as 0.1066913?! And as annoying as this all is, could POI follow that interpretation, simply because that is what a simple end-user would have expected? At least LibreOffice seems to know and do something, that POI does not. Cheers Andreas
