Issue 42646

Summary: Localisation ISO 8601
Product: General Reporter: holgerbruenjes <holgerbruenjes>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: acolomb, andre.schnabel, issues
Version: 680m77   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description holgerbruenjes 2005-02-12 22:34:14 UTC
In German -Spracheinstellungen -Sprachen -Gebietsschema, you can locate
Deutschland, but the format of the ISO 8601 etc. EN 28601  a DIN 5008 have also
the date format YYYY-MM-DD  

It is a problem to create a Schema 'Deutschland ISO 8601' with the date format


Comment 1 Olaf Felka 2005-02-14 09:08:13 UTC
Comment 2 gmr 2005-06-13 18:22:56 UTC
*** Issue 42646 has been confirmed by votes. ***
Comment 3 steinbrueck 2006-07-24 13:48:14 UTC
Still no recognition of Windows' localization settings. 
No way to format date according to ISO 8601, generated automatically in headers etc.
Comment 4 acolomb 2006-12-09 17:00:47 UTC
This problem is specific to both Windows and Unix operating systems. I don't
know about Macintosh.

When setting a cell to be formatted as an ISO 8601 date, it is displayed
correctly in the cell. However, the date representation when editing the cell is
determined by the "Language Settings -> Languages -> Locale setting" option.

That setting in turn does not honor the operating system's locale settings for
date and time formatting. Neither setting the date format in the regional
settings panel under Windows nor setting LC_TIME in Unix has the desired effect.

I even tried to change the locale definition and regenerate the locale, but it
seems that this behaviour is hard-coded and doesn't use the operating system's
locale definitions. (I might be wrong on that, didn't look at the OOo source
code yet)

There are several solutions to this issue (sorted best to worst):
1. Honor the OS's locale settings individually (including LC_TIME) and use their
locale definition
2. For this specific issue, change the de_DE locale to include the correct date
format according to ISO 8601 / DIN 5008
3. Provide the user with options to control the settings individually within OOo

Note about 2: ISO 8601 date formats have been the official date format in
Germany for more than a decade now. Since September 2006, (DIN) ISO 8601 is the
new obligatory standard in Germany, Austria and Switzerland.

I will also try to contact operating system vendors to encourage them to update
their locale definitions.

Regards, Andre