To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106840 Issue #|106840 Summary|date copied from calc to table produces warning (ooo3 |.2) and "no data" is copied or in ooo3.1 wrong date is | copied Component|Database access Version|OOO320m4 Platform|Unknown URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|paweljm
------- Additional comments from pawe...@openoffice.org Wed Nov 11 23:21:15 +0000 2009 ------- In calc spreadsheet I have table with 2 columns and one record, both cells contain value 30428 (this is valid for other values too), hoever, the format of the first cell is DATE and the other one is NUMBER: date1 date2 04/22/83 30428 I copy these 4 cells and paste as a new Table in Base, selecting field as Date: in Openoffice 3.1 date1 is correct 04/22/83 date2 is imported as 04/24/83 (2 days off !) in Openoffice ooo320m4 Java 1.6.0_17 I am getting Warning: Wrong data type: java.lang.IllegalArgumentException, continue anyway? date1 is correct 04/22/83 date2 is empty --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org