Mailinglist Archive: opensuse (4570 mails)
| < Previous | Next > |
Re: [SLE] OOo 2_0 enters dates as MM/DD/YY violating global KDE and YaST settings
- From: "Carlos E. R." <robin1.listas@xxxxxxxxxx>
- Date: Sun, 27 Nov 2005 14:46:44 +0000 (UTC)
- Message-id: <Pine.LNX.4.61.0511271416020.19105@xxxxxxxxxxxxxxxx>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The Saturday 2005-11-26 at 21:35 +0530, Shriramana Sharma wrote:
> I am using OOo 2_001 on SUSE 10.0 KDE 3.5RC1. I entered a date as 2005-11-26.
> It displayed it in the cell as 11/26/05. I got irritated.
I entered the same date, and got "26/11/05", which is correct for Spain.
> KDE Control Center > Regional & Accessibility > Country/Region & Language
> Short date format: DD-MM-YYYY
That does not affect OOo, I think.
> YaST > System > Date and Time
> has Region = Asia and Time Zone = Calcutta with Time and Date showing as
> 26-11-2005.
Neither.
> This being so, how come the program is showing me the American date format?
> Even if it did not display in the ISO format I entered the date in, it has no
> business using a regional setting other than what I have specified
> system-wide.
What does the command "locale" say? Mine says:
en_US.UTF-8
and if I leave OOo at "default" the same date as above shows as
"11/26/05", ie, US locale.
Therefore, either correct your system/user locale (it can be different for
each user, mind!), or simply tell OOo what is the exact "locale" you want.
I set it to "Hindi", and I got "26-11-2005". I'm not sure if it applies
only to new sheets or the current one also.
> I dug into the OOo Tools > Options > Language Settings > Languages menu and
> found that User Interface, Locale Setting are both at Default with only the
> Default Languages for Documents > Western being English (USA). Changing this
> to English (UK) does not help, even after restarting OOo.
Not "language/user interface", but "locale setting". I have the former set
to English (USA), but the later to "Spanish (Spain)". I don't like
translations. The "languages for documents" applies to the spell checker
and some other things, not to the date format.
- --
Cheers,
Carlos Robinson
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Made with pgp4pine 1.76
iD8DBQFDicaPtTMYHG2NR9URAnxpAJ9aPqtkUYsTTM9AoTLPAkPGGGoKUgCdEtvr
mpEDo5+qsw3oEVeprKf96jQ=
=i31A
-----END PGP SIGNATURE-----
Hash: SHA1
The Saturday 2005-11-26 at 21:35 +0530, Shriramana Sharma wrote:
> I am using OOo 2_001 on SUSE 10.0 KDE 3.5RC1. I entered a date as 2005-11-26.
> It displayed it in the cell as 11/26/05. I got irritated.
I entered the same date, and got "26/11/05", which is correct for Spain.
> KDE Control Center > Regional & Accessibility > Country/Region & Language
> Short date format: DD-MM-YYYY
That does not affect OOo, I think.
> YaST > System > Date and Time
> has Region = Asia and Time Zone = Calcutta with Time and Date showing as
> 26-11-2005.
Neither.
> This being so, how come the program is showing me the American date format?
> Even if it did not display in the ISO format I entered the date in, it has no
> business using a regional setting other than what I have specified
> system-wide.
What does the command "locale" say? Mine says:
en_US.UTF-8
and if I leave OOo at "default" the same date as above shows as
"11/26/05", ie, US locale.
Therefore, either correct your system/user locale (it can be different for
each user, mind!), or simply tell OOo what is the exact "locale" you want.
I set it to "Hindi", and I got "26-11-2005". I'm not sure if it applies
only to new sheets or the current one also.
> I dug into the OOo Tools > Options > Language Settings > Languages menu and
> found that User Interface, Locale Setting are both at Default with only the
> Default Languages for Documents > Western being English (USA). Changing this
> to English (UK) does not help, even after restarting OOo.
Not "language/user interface", but "locale setting". I have the former set
to English (USA), but the later to "Spanish (Spain)". I don't like
translations. The "languages for documents" applies to the spell checker
and some other things, not to the date format.
- --
Cheers,
Carlos Robinson
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)
Comment: Made with pgp4pine 1.76
iD8DBQFDicaPtTMYHG2NR9URAnxpAJ9aPqtkUYsTTM9AoTLPAkPGGGoKUgCdEtvr
mpEDo5+qsw3oEVeprKf96jQ=
=i31A
-----END PGP SIGNATURE-----
| < Previous | Next > |