https://bugs.freedesktop.org/show_bug.cgi?id=52019
--- Comment #3 from thack...@nexgo.de 2012-09-02 13:39:13 UTC --- Hello Gerdi, *, (In reply to comment #2) > seems that libreoffice has changed its compatibility to excel. maybe. But I have not used M$O for years ... ;) > until version 3.6 in the german version the input 23-07-12 let appear 23.07.12 > in the cell. O.K. But this is an other description as in your original report ... :( If I enter the date with dashes instead of dots, I get seemingly the US date format as well ... :( But this is different to what you have mentioned in comment #0 ... ;) If you compare the formating, you will see, that LO switches to "ISO 8601 (EN 28601, DIN 5008)" and Format-Code to "JJJJ-MM-TT", whereas your mentioned date in comment #0 has only Format-Code set to "TT-MM-JJ" ... ;) So LO is not switching to an other locale, but is switching to an ISO standard, which is – IIRC – used in industry and/or authorities ... ;) > since 3.6 12.07.23 appears. > i think the right way to input a date to calc would be 23.07.12 (with points > instead of the - in the numeric field (so you have not to drive left with your > hand to press the point), doing so appears 23.07.12. > as i tested in excel2007 with german localisation excel accepts 23-07-12 as > 23.07.12. Would be too much work for me as a workaround ... ;) > thank you for your message, a very good job has been done with version 3.6. You are welcome :) HTH Thomas. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs