| Summary: | Account Request: calc changes date format to non local format | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | gerdl <erdl> |
| Component: | contrib | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 3.6.0.0.beta1 | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| i915 platform: | i915 features: | ||
Hello gerdl, *, I cannot reproduce it with the Germanophone Version 3.6.0.2 (Build ID: 815c576) of LO under Debian Testing AMD64. Would you be so kind to test it with a newer version of LO than 3.6.0.0.1 Beta like the 3.6.0 RC2, please? TIA Thomas. 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 > 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. no more problems in later versions, expecially in version 4.0beta1 |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
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 3.6.0.0.1 and previous versions, no problems with 3.5.6 rc3. thank you Problem description: Steps to reproduce: 1. .... 2. .... 3. .... Current behavior: Expected behavior: Platform (if different from the browser): Browser: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:14.0) Gecko/20100101 Firefox/14.0