To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5556
------- Additional comments from dotanco...@openoffice.org Wed Jun 24 11:13:22 +0000 2009 ------- There seems to be a lot of confusion here. Let's summarize: When editing a date in Calc, the date format used to edit the date does not match the date format configured for the cell, nor does it match the date format configured in the user's locale. This bug complains about the edit date format not matching the format configured for the cell. Another bug may or may not exist (if there is, then please link to it) which complains about the edit date format not matching the date format configured in the user's locale. A related bug (bug 72229) requests that the edit date format be configured separately from either the date format configured for the specific cell or from the user's locale date format. Steps to reproduce this bug: 1) Right-Click on a cell -> Format Cells -> Numbers -> Category -> Date -> Choose format 31/12/1999 2) Enter into that cell my wedding day: September 2, 2005: 2/9/2005 What is displayed? February 9, 2005: the day of a car bombing. What is expected to be displayed? September 2, 2005: my wedding day. Note that on this system the configured locale date format is yyyy-mm-dd. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org