cells with local date format show the american format, not the german format.
1. create a new calc
2. define the cell as date, for instance in german 11.07.12
3. write a date in that preformatted cell just as 11.07.12 (day, month, year)
4. type enter
5. 12.07.11 appears in the cell, should be: 11.07.12. I think the local format is not used.
only with beta 126.96.36.199.1 and previous versions, no problems with 3.5.6 rc3.
Steps to reproduce:
Platform (if different from the browser):
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0
Hello gerdl, *,
I cannot reproduce it with the Germanophone Version 188.8.131.52 (Build ID: 815c576) of LO under Debian Testing AMD64. Would you be so kind to test it with a newer version of LO than 184.108.40.206.1 Beta like the 3.6.0 RC2, please?
seems that libreoffice has changed its compatibility to excel.
until version 3.6 in the german version the input 23-07-12 let appear 23.07.12 in the cell.
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.
thank you for your message, a very good job has been done with version 3.6.
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
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 :)
no more problems in later versions, expecially in version 4.0beta1