To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116960 Issue #|116960 Summary|Date cell decremented by 1462 when file opened Component|Spreadsheet Version|OOO330m20 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|steve73
------- Additional comments from [email protected] Mon Feb 14 17:58:26 +0000 2011 ------- I created a spreadsheet from a CSV file and saved it in ODS format. The sheet contains a date cell (as well as other data!). When I make a change to the sheet, save it and later on reopen it, the value in the date cell has been decremented by 1462 (just over 4 years). If I make another change to the sheet, save it and reopen it, again the value in the date cell is decremented by 1462. I started with a date cell having a year value of 2010 and after a number of edit save-open-cycles I now have a date cell with a year value of 1982. At no time do I make a direct edit of the date cell. I notice that someone else reported a vaguely similar issue no.106789 sometime ago. This problem seems different in that the date cell is affected when the sheet is change, saved and reopened. --------------------------------------------------------------------- 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]
