On Ubuntu Feisty I have OOo 2.2.0 installed. One of the columns of a certain spreadsheet is a date column, and I have specified in Format Cells -> Numbers -> Date the YYYY-MM-DD date format. However, OOo fails to recognize dates such as 14-09-2006 as a valid date, while a date such as 11-04-2006 (April 11th) is recognized and then converted to 2006-11-04 (November 4th). This seems to be because OOo has the days and months confused. How can I configure OOo to recognize xx-xx-xxxx as DD-MM-YYYY instead of MM-DD-YYYY? This is my locale info, if significant: LANG=he_IL.utf8 LC_CTYPE="he_IL.utf8" LC_NUMERIC="he_IL.utf8" LC_TIME="he_IL.utf8" LC_COLLATE="he_IL.utf8" LC_MONETARY="he_IL.utf8" LC_MESSAGES="he_IL.utf8" LC_PAPER="he_IL.utf8" LC_NAME="he_IL.utf8" LC_ADDRESS="he_IL.utf8" LC_TELEPHONE="he_IL.utf8" LC_MEASUREMENT="he_IL.utf8" LC_IDENTIFICATION="he_IL.utf8" LC_ALL=he_IL.utf8 [EMAIL PROTECTED]:~$
Note that my KDE install is in Hebrew, however OOo is in English. It is set to use the User Interface and Locale "default", which in my opinion should be Hebrew. Gnome (which I do not use) _may_ be set to English. I cannot open Gnome however, due to a stupid fault of the ATI proprietary drivers (long story). So configuring OOo to respect the KDE defaults may solve this problem. How is that done? Thanks in advance. 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?
