To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106992
------- Additional comments from [email protected] Tue Feb 9 00:49:16 +0000 2010 ------- Not using an ambiguous date format is VERY VERY important. Please considered raising the priority of this bug and getting it fixed it ASAP. This is probably a source of frustration for a lot of Canadian users. It took me a long time to find this. It shouldn't be hard to copy the correct short date format from the "French(Canada)" locale. Canadians by statue should use CSA Z234.5:1989 date format for short dates which is equivalent to ISO 8601, where short dates are store/entered as YYYY-MM-DD ex 2010-02-26. Using ISO standards ensure there is no confusion between months and days, nor year 2000 type issues. Unfortunately there is a bug in OOO310m19 Build 9420 (English - Canada) locale data (I'm using the Windows build on Windows 7 Pro at the moment) which incorrectly uses a confusing US like date format. Making changes to the defaults or the Windows locale settings has no effect on this bug. This bug is visible in calc when you start a new spreadsheet, enter a date using ISO 8601 ex 2008-02-26 and then look at the formula/data entry window after you hit enter. If you have set "Options->Language Settings->Language of Local setting" to "English (Canada)" it will incorrectly display 26/02/2008. If you change that same setting to "French (Canada)" and leave everything else in the Lanuages set at Default or "English (Canada)" the date format is correctly displayed as "2008-02-26". This issue can lead to data entry errors and should be fixed ASAP. A temporary work around is to set "Options->Language Settings->Language of Local setting" to "French(Canada)" but it is unclear what other undesirable side effects this will have. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
