Issue 42646 - Localisation ISO 8601
Summary: Localisation ISO 8601
Status: CONFIRMED
Alias: None
Product: General
Classification: Code
Component: ui (show other issues)
Version: 680m77
Hardware: All All
: P3 Trivial with 15 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-02-12 22:34 UTC by holgerbruenjes
Modified: 2013-02-07 22:40 UTC (History)
3 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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
YYYY-MM-DD

Thanks

Holger
Comment 1 Olaf Felka 2005-02-14 09:08:13 UTC 
reassigned
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