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.
MSO Excel respects this, at least as configured at my
university. How can I configure OOo Calc to do this as well?
What you expect is an automagical auto-formatting which magically
guesses some number format from your input and applies it. As far as I
know, Excel does not do this.
You've got to enter all 3 numbers for year, month and day including the
leading "20", the dashes and the leading "0" in "-01", which is not what
most users want to do.
I bet you work with text values and Excel treats numeric text
automatically as numbers (automatically evaluating the same text
differently on different systems!).
This will work similarly in OOo 3.2. However, OOo will accept numeric
strings only if they represent an ISO-time or integer number. So you may
enter the fully formatted ISO dates as text.
What does your Excel evaluate when you enter "1/2/3"? 1st February, 2nd
January 2003, 3rd February 2001? Does it display "1/2/3" as a formatted
number or as text?
That is nice, but it is not what I need. I need the dates to be set as
yyyy-mm-dd by default, as opposed to their current default which is
confusing to those not familiar with American dates.
Why by default? This is impossible to do and there is no workaround
other than using the program that works for you.
Calc's behaviour is almost the same as in all versions of Excel I know
(-2003). It is perfectly acceptable since there is always a clear
distinction between numbers and text, many alternative input methods and
a hierarchical system of cell styles.
My OOo never shows any US formatting unless I tell it to do so.
If I tell nothing (all default), some US user will see US figures, but
that should be no problem at all.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
