On 19/01/2008, TomW <[EMAIL PROTECTED]> wrote: > I am not sure it is really a bug, but just the way different languages > implement the ISO 8601 format. When setting a date format such as > yyyy-mm-dd, the ISO format code is displayed in the dialog box. > Swedish(Sweden) is ISO 8601 (EN 28601) and displays 2008-01-19 in the > input box and the cell. Swedish(Finland) is ISO 8601 (EN 28601), but > shows 19.01.2008 in the input box and 2008-01-19 in the cell. > German(Germany) is ISO 8601 (EN 28601 DIN 5008), shows 19.01.2008 in the > input box and 2008-01-19 in the cell. I have not delved deeply into to > how this ISO 8601 is implemented on a country by country basis to see if > it is an actual Calc bug or not.
ISO 8601 specifies that the highest order value will be the leftmost value, and the values are displayed in decending order. Thus, the Finish-SW display of 19.01.2008 is not valid ISO 8601. Furthermore, I'm near certain that ISO 8601 requires dashes separating the date values and colons separating the time values, with either a T or a space between them. One could optionally remove all separators, and any lowest level value is valid so long as all levels above it are in place. Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing?
