> In my understanding OO.o takes the setting for date input format from > your computers "short date" locale setting by default (thus my input > date format is 31/12/99). This i believe is sensible as the date is best > entered in a familiar short format.
That makes perfect sense. > Is this not the case in your > computer? No, my short date format is set as "YYYY-MM-DD" in KDE's System Settings. I wonder, might OOo only read the Gnome setting, and being non-existent OOo is defaulting to MM/DD/YY? > (Check"Tools- Options... Language Settings- Languages"). It is all set to Default. > Can > you set the Locale Setting value to a different country and report back > if this makes a difference? > Ah, yes, changing that to Dutch does change the default date format to DD/MM/YY. Must I now go through all the settings to find which has the short date format of YYYY-MM-DD? Or can I simply configure it somewhere (even in locale outside OOo)? > And IIUC the format for calc cells can be set seperately at "Format - > Cells... Numbers - Language" (not tested here). > Note quite a solution as it would have to be set for every sheet. > In linux compare: > $ date > $ date +%c (taken from locale) > $ date +%D > $ date +%x (taken from locale) > $ date -I Exactly, neither of the locale-based formats use the MM/DD/YY format: karm...@kubuntu:~$ date Sat Nov 14 23:18:42 IST 2009 karm...@kubuntu:~$ date +%c 2009-11-14T23:18:49 IST karm...@kubuntu:~$ date +%D 11/14/09 karm...@kubuntu:~$ date +%x 2009-11-14 karm...@kubuntu:~$ date -I 2009-11-14 > It may be possible to set the locale date format strings (long or short) > for some computers to a preferred non-standard option. You could create > a custom localization and tinker with it (especially in linux - see > /usr/share/locale/). But this would be a last resort. In addition my > linux box has three locales possible for New Zealand. I am not going to > explore the difference, though i do believe it has more to do with the > character codeset in use than aything else(UTF-8, ISO-9950-1 and > default). > How exactly can one see what the differences are? I actually would not mind making a custom locale for my own use, but this issue affects other users as well. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
