Copying a table cell to clipboard

Getting your data onto paper - or the web - Discussing the reports features of Base

Copying a table cell to clipboard

Postby andyonio » Thu Jun 18, 2015 6:45 pm

I need to copy the content of a table cell, that is displayed in a form control, to the clipboard, so that I can paste it to a Word page.
Any help?
Thanks
LibreOffice 4.1 on Windows XP
andyonio
 
Posts: 7
Joined: Tue Jun 16, 2015 1:41 pm

Re: Copying a table cell to clipboard

Postby RoryOF » Thu Jun 18, 2015 6:46 pm

Does selecting it and Ctrl C not work?
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29431
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Copying a table cell to clipboard

Postby andyonio » Thu Jun 18, 2015 7:02 pm

It works, but...
As a matter of fact, I need a pushbutton that copies the content of several comboboxes or listboxes , with their labels, in a queary to the clipboard.
Then i could paste it to the page of another running application I cannot modify, but that accepts the pasted text.
Can a report be changed to plain text and pasted to clipboard?
Thanks
LibreOffice 4.1 on Windows XP
andyonio
 
Posts: 7
Joined: Tue Jun 16, 2015 1:41 pm

Re: Copying a table cell to clipboard

Postby MTP » Fri Jun 19, 2015 3:52 pm

If your report is based on a query, you can import the query results to Calc: [Tutorial] Using registered datasources in Calc. In Calc, it would be easier to highlight all the content plus the labels for copying.

Short of that, I believe you'd need a macro. Definitely possible, but comes with a steep learning curve. If you want to tackle the macro way, I like sheepdogguides to start with and Andrew Pitonyak's OpenOffice Macros Explained as a resource for more advanced stuff.
OpenOffice 4.1.1 on Windows 10, HSQLDB 1.8 split database
User avatar
MTP
Volunteer
 
Posts: 1620
Joined: Mon Sep 10, 2012 7:31 pm
Location: Midwest USA


Return to Reporting

Who is online

Users browsing this forum: No registered users and 1 guest