Issue 111465

Summary: [Sqlite-ODBC] Paste from Calc to Base table ignores current clipboard contents
Product: Base Reporter: h1onooo <heinz.repp>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 3.2   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description h1onooo 2010-05-07 20:46:37 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.
Comment 1 drewjensen.inbox 2010-05-08 16:32:05 UTC
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.
Comment 2 h1onooo 2010-05-09 20:27:35 UTC
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.
Comment 3 john_ha 2010-07-02 13:32:53 UTC
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.