Dotan Cohen wrote:
On 17/01/2008, Robin Laing <[EMAIL PROTECTED]> wrote:
Thanks for that info. I tried setting LC_TIME="en_DK.utf8" which uses
the YYYY-MM-DD format, but this did not change Calc's behaviour. What
locale parameter should I change?
Dotan, this has been one of my pet peeves in Linux. I think the best
option is to ask the distro mail list for the version of Linux you are
using. I feel that it is now time to have Linux use ISO dates by
default. Of course I feel the same way about OpenOffice.
$ locale
LANG=en_DK.utf8
LANGUAGE=en_DK.utf8
LC_CTYPE="en_DK.utf8"
LC_NUMERIC="en_DK.utf8"
LC_TIME="en_DK.utf8"
LC_COLLATE="en_DK.utf8"
LC_MONETARY="en_DK.utf8"
LC_MESSAGES="en_DK.utf8"
LC_PAPER="en_DK.utf8"
LC_NAME="en_DK.utf8"
LC_ADDRESS="en_DK.utf8"
LC_TELEPHONE="en_DK.utf8"
LC_MEASUREMENT="en_DK.utf8"
LC_IDENTIFICATION="en_DK.utf8"
LC_ALL=en_DK.utf8
$ openoffice.org2.3 -calc
Now, I select column A -> Format Cells -> Numbers -> Category -> Date
-> Format -> 1999-12-31. I now enter "2008-1-16" into cell A1 and hit
enter. The cursor moves to cell A2 and I see "2008-01-16" in cell A1.
So far so good. Now, I click on cell A1. The cell still says
"2008-01-16" however the input line reads "01/16/2008". AGGGHHHH.
Please, tell me what I'm doing wrong, or what I'm leaving out. If I'm
not doing anything wrong, and I haven't left anything out, then I'll
file this as a bug.
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?
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
