-----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-----