To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=75196 Issue #|75196 Summary|Spreadsheet to Database date conversion still faulty Component|Database access Version|OOo 2.0 Platform|Opteron/x86_64 URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|david_webb
------- Additional comments from [EMAIL PROTECTED] Wed Mar 7 11:27:35 +0000 2007 ------- If I copy the following table from the OO Spreadsheet: ========================== Date Event 01/01/45 Birth 01/01/75 Marriage 01/01/95 Death ========================== and paste it in a spreadsheet/table window, using the copy table options to create a primary key and to make the date field type "date [DATE]" or "date/time [TIMESTAMP]", then the copy works but I get a table like: ========================== ID Date Event 1 03/01/45 Birth 2 03/01/75 Marriage 3 03/01/95 Death ========================== where the dates are off by two days. The problem is probably due to a difference of two days in the 'base date' (origin?) used by the OO spreadsheet and database programs. Issue 23878 discusses a similar problem but the issue is marked as closed. --------------------------------------------------------------------- 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]
