On 12/21/2009 11:09 AM, Dotan Cohen wrote: >>> You might be used to OOo Calc changing your date formats for you on >>> the fly, but I enter dates in the format that I would like to use >>> them. >> >> That's exactly what Calc does *not* do. It applies the format *you* have set >> or some default which depends on it's own locale (Hebrew, German, UK >> English, whatever) independently from the operating system. >> > > I insist that it doesn't. Starting from a clean ~/.openoffice.org > configuration, what must I configure to have calc use the yyyy-mm-dd > format by default? This is my locale info: > $ locale > LANG=he_IL.utf8 > LANGUAGE= > LC_CTYPE="he_IL.utf8" > LC_NUMERIC="he_IL.utf8" > LC_TIME=en_DK.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= > $ date +%x > 2009-12-08
Something looks odd there; shouldn't the 'en_DK.utf8' in LC_TIME be enclosed in quote marks? $ locale LANG=en_US.UTF-8 LANGUAGE=en_US.UTF-8 LC_CTYPE="en_US.UTF-8" LC_NUMERIC="en_US.UTF-8" LC_TIME="en_US.UTF-8" LC_COLLATE="en_US.UTF-8" LC_MONETARY="en_US.UTF-8" LC_MESSAGES="en_US.UTF-8" LC_PAPER="en_US.UTF-8" LC_NAME="en_US.UTF-8" LC_ADDRESS="en_US.UTF-8" LC_TELEPHONE="en_US.UTF-8" LC_MEASUREMENT="en_US.UTF-8" LC_IDENTIFICATION="en_US.UTF-8" You might try experimenting with setting LC_DATE. I did find that if I set the Default style (in OOo Calc) to Swedish (Sweden) and then the Date format to YYYY-MM-DD, the numbers displayed in the cell and in the formula bar are 2009-12-13. So that may be worth experimenting with also. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
