To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79609 Issue #|79609 Summary|Calc doesn't handle ISO dates correctly Component|Spreadsheet Version|OOo 2.1 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|marcsinclair
------- Additional comments from [EMAIL PROTECTED] Fri Jul 13 21:59:44 +0000 2007 ------- If I enter a date in ISO standard date formats (YYYY-MM-DD, YYYY-MM-DD HH:MM and YYYY-MM-DD HH:MM:SS) Then it is converted into some foreign, non statndard format. Although formatting the cells to 1999-12-31 then shows the date correctly in the cells, editing the cell then reverts the date to some other foreign, non standard format. The program should not disclose its internal working format, which should be the ISO standard anyway! double clicking on the cell should allow editing in the preset format, or at least, the system format. Marc Sinclair --------------------------------------------------------------------- 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]