On Wednesday 16 January 2008 21:25:03 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
The formatting in the Input line seems to be set by the language you pick
in the Formating window where you set the formating characteristics of your
cell. That is why I said I doubt that you could get the YYYY-DD-MM format in
the Input line unless you know of a language which uses that as its default
date format. Language as in English, Spanish, Russian, etc.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
