Johnny Rosenberg wrote:
2009/12/11 Andreas Saeger <[email protected]>:
Dotan Cohen wrote:
Please, please, this is killing me.
$ date +%x
2009-12-08
However, Calc insists on using the mm/dd/yy year format in new
documents. The settings under Language are all Default. What must I do
to have OOo respect the locale settings?
That's strange. I have Ubuntu 8.10 and OpenOffice.org Calc 3.1
(vanilla version - not the Ubuntu version) and the default format
seems to be YY-MM-DD, which indeed is the Swedish default format.
Which OpenOffice.org language pack is installed on your system?
Johnny Rosenberg
OOo's GUI language is completely independent from the text language and
number formatting.
This thread is about number formatting which depends on
Tools>Options...LangSettings>Languages: "Locale Setting".
If this is set to "Default", then OOo will read the operating systems
locale (and the locale only!) and apply its own setting according to
en-US, de-DE, fr-CN, sv-SE or whatever the system uses as language. It
will not read any customized locale settings from the system.
OOo applies its own locale settings according to the explicitly set
locale or the system locale respectively. A US date always looks the
same when you open the same document on different systems, even if the
current user set some different date format on the operating system
level. This is intended.
Messing around with the locale setting in order to manipulate the
defaults does not satisfy anyone. A Swedish locale for instance, uses a
comma as decimal separator.
Simply use the application as is.
Do not bother at all about the number formats. They are not important.
Use templates with a set of customized styles to format spreadsheet
cells explicitly in any way you like.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
