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?
I know that this issue has been addressed tens of time on the list but
I cannot find the "answer" in the archives.There is a bug (or rather,
several) on the issue but I think that I saw a method or workaround
posted once on the list but I cannot find it.
Your locale setting is "Default" and your operating system locale is US
English. The program accepts your locale using its own setup for this
particular locale, so your document will look exactly the same on other
systems. It makes no sense to use the current system's customized locale
settings when documents have to be exchangable across systems. There is
no bug, since the number formatting behaves exactly as it has been
designed intentionally.
Simply use the given formatting facilities, styles in particular, in
order to override the plain defaults.
Btw: The format of a number is completely irrelevant as long as the
value is the correct number. No calculation result depends on number
formatting.
8/12, 12/8, 2009/12/08, it's all the same day number 40155 or 4015500%,
$40155.00, 40.155,00€, ...
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org