Dotan Cohen wrote:
On 18/01/2008, TomW <[EMAIL PROTECTED]> wrote:
Dotan:
I found that I could get your desired format (yyyy-mm-dd) in both the
cell and the input line by changing the language in the cell formatting
dialog to Swedish(Sweden). This is with my language set to US English in
the OpenOffice Options - Language Settings. This worked in Windows XP
SP2 OO2.4dev and a Linux Vitual Machine(Kubuntu)OO2.0.
This allows you to keep the language you are working in, but select a
different language for the cells you need to format in a unique way.
TomW
Thanks for the tip, Tom. That is a workaround, not a solution. I'll
file the bug and report back.
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?
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.
Just my thoughts,
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
