https://bugs.freedesktop.org/show_bug.cgi?id=53177
--- Comment #8 from joaquin <[email protected]> --- (In reply to comment #6) > A quick test with "LibreOffice 3.6.3.2” German UI/ German Locale [Build-ID: > 58f22d5]" on German WIN7 Home Premium (64bit), but I did not see Dates with > "/"? Where do you get the impression that ther should be "/" somewhere? This is not about the separator between days, month, year. Tak a look at the following web page: https://www.asnbank.nl/asnappl/scripts/koersen/koersen.asp?dnid=9404 Next Friday, 02 November some hours after 10:00, you will see something like: 02-11-2012 ..fonds: 60,46 > @joaquin: > Please reduce your sample document to the relevant table and follow my > instructions in Comment 1, what for example means that you write something > like "Sheet1.A7" is shown as "xx/yy" but I expect "yy/xx" because "..." (and > not "all numbers with ..." - open the attachement 69221 - Set your locale to somethen non-US (German will do). Set your global setting - Preferences (tools->options) -> Load/Save -> HTML Compatibility [v] Use English (USA) locale for numbers So I expect LibreOffice to import just the date and number above and only influence numbers as described in bug 56457. Instead LibreOffice first swaps the day and month, than puts the following result in a text field: 11-02-2012 ....fonds: 60,46 or whatever value the mutual fund has at the opening at 10:00. So LibreOffice imports dates incorrect one third of the month when using most non-US locales in combination with "Use English (USA) locale for numbers". Do you follow me? Do you understand that I use this to keep trac -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
