https://issues.apache.org/ooo/show_bug.cgi?id=71997
--- Comment #10 from j2006 <[email protected]> --- Created attachment 79892 --> https://issues.apache.org/ooo/attachment.cgi?id=79892&action=edit numbers as text, days & months swaped This attachment illustrates the odd behaviour of the setting: Load/Save -> HTML Compatibility -> Use English (USA) locale for numbers You will notice that this setting, combined with a global locale setting other than USA that uses a "," as decimal separator, like Dutch (Netherlands), German, .. (but not something with DD-MM-YYYY for dates and a decimal dot like English UK) will cause the following behaviour: - days are swapped with months when day-of-month < 13 - dates are imported as text - numbers without a decimal dot are imported as text see https://bugs.freedesktop.org/show_bug.cgi?id=47109 Not using: Load/Save -> HTML Compatibility -> Use English (USA) locale for numbers and using a non-USA locale with a decimal "," makes matters worse by importing numbers with a decimal dot without the dot: https://bugs.freedesktop.org/show_bug.cgi?id=56457 -- You are receiving this mail because: You are on the CC list for the bug.
