On Sat, 14 Nov 2009 18:22:14 +0200 Came this utterance formulated by Dotan Cohen to my mailbox:
> > Bug #5556 mentions the fact that the input line for dates differs from > the configured date format. I can understand where that would be > useful (in fact, I would use it often) however in the current case the > input format is the US date format, which is not known outside the US > and is counter intuitive (the smallest units are in the middle, not on > the left or right side). This leads to dataloss as OOo interprets the > dates not as the user intended when entering them. > > 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. Is this not the case in your computer? (Check"Tools- Options... Language Settings- Languages"). Can you set the Locale Setting value to a different country and report back if this makes a difference? And IIUC the format for calc cells can be set seperately at "Format - Cells... Numbers - Language" (not tested here). In linux compare: $ date $ date +%c (taken from locale) $ date +%D $ date +%x (taken from locale) $ date -I 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). HTH -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
