NoOp wrote:
On 11/14/2009 11:47 AM, Dotan Cohen wrote:
On Kubuntu 9.10 with OOo 3.1 (probably Go-OOo) with the Language
Options set to use the default locale setting:
!) With export LC_ALL="en_DK.UTF-8" (which uses the YYYY-MM-DD
format), entering date as YYYY-MM-DD:
Calc shows "MM/DD/YY" in the cell, and "MM/DD/YYYY" in the formula
bar. F2 for cell edit changes the cell display to "MM/DD/YYYY" for the
duration of the edit.
I set LC_ALL to null and simply set LC_TIME to whatever format I wish.
LC_ALL takes presidence over all other LC_x settings. See:
http://opengroup.org/onlinepubs/007908799/xbd/envvar.html
[see: Internationalisation Variables]
https://help.ubuntu.com/community/Locale
[note the ubuntu page should be updated to reflect the info in the first
link]
<snip>
But isn't this all just a little arcane and requires deep digging, when
I would've thought that the default /should/ be that the date format
corresponds to that set in the user's locale. Then, if the user wants
to mess under the hood for some other date formatting, then s/he can do so.
