To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103041 Issue #|103041 Summary|Date edit format does not match configured date format Component|Spreadsheet Version|OOo 3.1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|dotancohen
------- Additional comments from [email protected] Tue Jun 23 14:06:40 +0000 2009 ------- When editing a date in Calc, the date format used to edit the date does not match the date format configured for the cell. Steps to reproduce: 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 did I expect to be displayed? September 2, 2005: my wedding day. I presume that Calc is using the OS's configured locale for entering dates, alas, this is _not_ the expected behaviour. I expect the OS's configured locale to be used right up until the point that the user configures a different format. When that different format is configured, I expect it to be used in all relevant situations. That means both viewing _and_ editing. Thanks. --------------------------------------------------------------------- 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]
