Issue 49320 - Can't copy query result table/rows to clipboard in Base
Summary: Can't copy query result table/rows to clipboard in Base
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 680m100
Hardware: PC Windows NT
: P3 Trivial (vote)
Target Milestone: OOo 3.2
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
: 56893 (view as issue list)
Depends on: 52915
Blocks:
  Show dependency tree
 
Reported: 2005-05-15 22:45 UTC by macuser_winpgmr
Modified: 2009-09-06 13:37 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
incomplete patch (10.09 KB, patch)
2005-08-26 14:37 UTC, Frank Schönheit 		no flags Details | Diff
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description macuser_winpgmr 2005-05-15 22:45:34 UTC 
In Access, it's common to run a query interactively or via Automation, then use
Select All and Copy to copy the query result table to the clipboard. This table
can then be pasted into Excel or Word.

In Base, Copy only appears to copy the contents of one cell to the clipboard.
This can't be right. Even after selecting multiple rows in the result table,
copy only puts a single value on the clipboard.
Comment 1 Frank Schönheit 2005-05-17 14:45:33 UTC 
confirming, targeting, grabbing.

Edit|Copy in the table/query data view currently copies the content of the
active cell only, instead of the selected row(s), which would be much more
expectation conformant.

Workaround:
Drag'n'Drop the row(s)
Comment 2 Frank Schönheit 2005-08-26 14:37:13 UTC 
Created attachment 29084 [details]
incomplete patch
Comment 3 Frank Schönheit 2005-08-26 14:40:33 UTC 
attached file is an incomplete patch, which adds the "Copy" functionality. Also,
a "Copy" entry is added to the row context menu.
What's not yet working:
- the current selection is ignored ATM, it's always the whole table/query which
is copied
- do we need paste handling as well?
Comment 4 gsking1 2005-10-05 02:37:39 UTC 
The entire query result can by copied using this method:  before running query
click right click the query you want and click 'copy'; then go to calc and
paste. this gives you the whole table/query results.

I'm not sure this works for everything, but i've done it a few times.  It's
counter-intuitive so i think we need something closer to what access has.
Comment 5 ocke.janssen 2009-06-03 14:01:26 UTC 
*** Issue 56893 has been marked as a duplicate of this issue. ***
Comment 6 ocke.janssen 2009-06-05 09:48:00 UTC 
Fixed in cws dba32e
Comment 7 ocke.janssen 2009-06-05 09:50:11 UTC 
grabbing.
Comment 8 ocke.janssen 2009-07-16 07:44:48 UTC 
Please verify. Thanks.
Comment 9 marc.neumann 2009-07-22 13:49:18 UTC 
verified in CWS dba32e

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba32e
Comment 10 r4zoli 2009-09-06 13:37:10 UTC 
Verified in DEV300_m57. Closing.