To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80463 Issue #|80463 Summary|Change Excel import-/export filters to correct wrong d |ates 1.1.1900 - "29.2.1900" Component|Spreadsheet Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|ENHANCEMENT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|a0071
------- Additional comments from [EMAIL PROTECTED] Wed Aug 8 09:06:42 +0000 2007 ------- If you import an Excel spreadsheet with dates btween 1.1.1900 and 1.3.1900, f.e. 20.1.1900, this date is imported in Calc as 19.1.1900 due to the "bug" in Excel, that 1900 is a leap year (has the day 29.2.1900). When importing it should be easy to convert these dates to the right value in Calc and reconverting it to the Excel value, when exporting to Excel. --------------------------------------------------------------------- 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]