To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73810 Issue #|73810 Summary|Mangled date when copy/paste from Excel formatted tabl |e Component|Spreadsheet Version|OOo 2.0.4 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|degerrit
------- Additional comments from [EMAIL PROTECTED] Tue Jan 23 16:34:14 -0800 2007 ------- I have as of yet been unable to reproduce this "from scratch" using only OpenOffice, only with the attached document which will follow. Open this XLS or ODS document which contains dates formatted as Date:DD/MM/YYYY Copy the dates, make a new spreadsheet, paste them. Weird things happen: 11/12/2001 becomes 10/12/1997 08/11/2002 becomes 07/11/1998 16/11/2002 becomes 15/11/1998 12/12/2002 becomes 11/12/1998 11/11/2003 becomes 10/11/1999 30/11/2004 becomes 29/11/2000 13/11/2005 becomes 12/11/2001 Copy/pasting within the same spreadsheet works correctly. The problem is still reproducable though even when first saving the XLS file as ODS file. --------------------------------------------------------------------- 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]