Dotan Cohen wrote:
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
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.
--
Robin Laing
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
