On 16/01/2008, Dan <[EMAIL PROTECTED]> wrote: > On Wednesday 16 January 2008 09:49:27 Dotan Cohen wrote: > > I have a Calc document (created in Calc as ods) with a date column. In > > Format Cells -> Numbers -> Category -> Date -> Format I have set > > 1999-12-31. When I enter dates (only in that format) they display > > fine. However, if I select a cell and choose "default formatting" then > > the cell displays a number. For instance, for the date 2008-16-01 I > > choose default formating and it turns into 39463. > > > > Note that before the conversion, when selecting a cell with a date, > > although the cell displays 2008-16-01 the edit bar at the top of the > > app displays 16/01/2008. After the default formatting, both the cell > > and the edit bar show 39463. > > > > Now, the questions: > > 1) How do I get OOo to display the date as I've configured it to, even > > after applying default formating to a cell? > > 2) How do I get OOo to display the date as I've configured it to in > > the edit bar as well as the cell? > > > > 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? > > OOo stores the date as a number regardless of the date format you use. In > this case, 39463 is the number OOo associates with the date Jan 16, 2008. All > your date format does it to take the number and convert it to the desired > format. > 1) Change the formating in the cell back to what you want it to be. > 2) You don't. The date in the cell follows the date format you give it. > The date in the edit bar (Input line in English[USA]) follows the default > configuration for the language you are using. So, unless you find a language > which has a default date format of YYYY-DD-MM, the edit bar will not display > this format. > > Dan
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 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?
