Dotan Cohen wrote:
In both Writer tables and in Calc, when I enter a date in YYYY-MM-DD
format it gets reformatted as MM/DD/YY. My locale is set for the
YYYY-MM-DD format, and OOo is configured to use the default locale
settings. So where is this MM/DD/YY date coming from? How can I change
it on a global basis?
Thanks.
The default formats for number formats are a set of locale
configurations for all supported locales. The localization projects are
responsible for that and quite a lot of the locale data are wrong or
inapropriate.
If the number format locale of a table cell, a field, a form control is
"Default", then the application locale takes place.
If that one is "Default" too, OOo reads the LOCALE and only the locale
(language_Country) from the respective operating system in order to
apply it's own locale settings. OOo does NOT store any information about
the individual customizations on OS level.
This way a localized figure looks the same on any system, using any
version of the program.
When you enter some sequence of characters in Calc, the whole string
gets evaluated as a formula if it starts with a = (and possibly + or -).
In any other case it is evaluated as a numeric expression in the context
of the cell's number format locale (most important: dot-decimals vs
comma-decimals) and in the context of the number format group (most
important: percent).
The number format named "General" in English context (or "Standard" in
some other locale context) is the one and only number format which
applies ONE DISTINCT number format per number format group automatically.
In the context of some locale and number format "General"...
When you enter a string that looks like a date, ONE DISTINCT date format
is applied (mostly with 2-digit years).
When you enter a string that looks like a percent, ONE DISTINCT percent
format is applied (mostly with 2 decimals).
When you enter a string that looks like a currency, ONE DISTINCT
currency format is applied (mostly with 2 decimals).
and so on.
Using explicit number formats, you can enter anything which looks like a
date/percent/currency/boolan or anything else, the figure will always be
displayed in the set number format. Any date/time is a number, any
number can be a date/time. As a matter of fact there are no date/times
nor booleans in Calc.
Number format "@" (group "Text") supresses all evaluation, leaving the
literally entered input string as a text value.
So we have a wide variety of number formats in 130 or so language
contexts and 2 special formats "General" (semi-automatic) and "@"
(supress evaluation).
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
