Apache OpenOffice (AOO) Bugzilla – Issue 111465
[Sqlite-ODBC] Paste from Calc to Base table ignores current clipboard contents
Last modified: 2013-01-29 21:47:08 UTC
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.
Checked this with OO.o 3.2 under Vista and Ubuntu 10.04 and could not reproduce the problem. Both cases however I used the embedded HSQl driver - I will try on XP against a SQlite/ODBC connection also.
confirming: on Ubuntu 10.04 I can not reproduce the bug. Maybe this happens on XP only, as the origin is likely located in the system clipboard vs. application clipboard handling - and this is system specific.
This appears to be very similar to "Paste from clipboard pastes the previous contents of the clipboard" at http://www.openoffice.org/issues/show_bug.cgi?id=110217 which, while reported as a Writer problem, also happensd with Calc and Impress, suggesting that it is generic OO problem. Other forums have similar posts - this Mozilla forum entry is interesting - it seems to be the same problem and seems to have been analysed as a race problem. http://netbeans.org/bugzilla/show_bug.cgi?id=88161 If it is a race hazard, this would explain why it is intermittent.