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?
