Bug 52019 - Account Request: calc changes date format to non local format
Summary: Account Request: calc changes date format to non local format
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: contrib (show other bugs)
Version:
(earliest affected)
3.6.0.0.beta1
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-12 16:38 UTC by gerdl
Modified: 2012-12-08 09:18 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description gerdl 2012-07-12 16:38:05 UTC
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
Comment 1 Thomas Hackert 2012-07-29 16:45:33 UTC
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.
Comment 2 gerdl 2012-08-02 07:50:57 UTC
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.
Comment 3 Thomas Hackert 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.
Comment 4 gerdl 2012-12-08 09:18:42 UTC
no more problems in later versions, expecially in version 4.0beta1