To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=42646
User acolomb changed the following:
What |Old value |New value
================================================================================
CC|'andreschnabel' |'acolomb,andreschnabel'
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Sat Dec 9 09:00:47 -0800
2006 -------
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
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
