To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104318 Issue #|104318 Summary|Copy/paste of TIME fields from Calc to Base fails Component|Database access Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|comtinux
------- Additional comments from [email protected] Tue Aug 18 14:59:08 +0000 2009 ------- Having the following configuration: - 1 "input" .ods file containing data to import into the database, with the form: 1st line contains .odb's table T column headers, and next lines contain data - 1 "output" .odb file connected to a PostgreSQL 8.3 ODBC datasource with read+write rights on a given table T The import method used between Calc and Base is : - copy selected data from Calc (header+data lines) - paste in Base by applying it on table T, and then by completing Base's "paste wizard" The problem: Any Calc cell with type TIME (e.g. 12:34:56) is pasted in Base column with SQL type TIME as 00:00:00. Whatever the content of the input Calc cell is. This problem occurs with no particular error or warning message, giving the user the impression that the paste from Calc into Base is ok. What is expected: The content of Base columns with type TIME should be pasted with values coming from the copied Calc "TIME" cells, not 00:00:00. --------------------------------------------------------------------- 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]
