To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111465 Issue #|111465 Summary|Paste from Calc to Base table ignores current clipboar |d contents Component|Database access Version|OOo 3.2 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|h1onooo
------- Additional comments from [email protected] Fri May 7 19:46:37 +0000 2010 ------- How to reproduce: Open database with more than one table (in my case: Sqlite-ODBC based) Open one table, select multiple rows and copy them Open new spreadsheet and paste Remove formatting (that is another issue: pasting from database into Calc lets you choose only between HTML and RTF formatted text, unformatted is not available) and edit data Select all data and copy them Right-Click on original table in database and select paste A dialag allows you to match fields and append the modified data to the table so far it works ... But now do exactly the same to another table of the same database - preferably with different structure: Select multiple rows and copy them Paste them into a new spreadsheet, remove formatting and edit Copy the modified spreadsheet data and try to paste them to the second table The data Base tries to append to the second table are from the first one, those copied modified from the first spreadsheet. With different structures it is obvious that the fields do not match. The Windows clipboard holds the new table/spreadsheet 2 data, as can be verified with the clipboard viewer or by pasting them to different programs, even Writer or Calc, but Base has still the modified table 1 data as can be seen when pasted to a new table. Where does Base keep the old clipboard contents? Seems it refuses to release it when the system (Windows) clipboard contents changes. Workaround: Close database and open it again: this time it will paste the current clipboard contents - no need to copy it again. --------------------------------------------------------------------- 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]
