On 3/02/2015, at 22:55, Mark Stanton <mark@vowleyfarm.co.uk> wrote:
I've been thinking about this.
Firstly, the cut'n'paste solution isn't working here for me on the results (23 rows, perhaps ten
columns) of a query in SQL view with Fedora Linux (20) and LO 4.2.8.2 (please don't suggest I
upgrade to the latest as I'm using the OS repos, and there hasn't been any work on Base in that
time anyway)(has there?). It doesn't work in design
view either I now find.
You do not select the cells from an open query.
Just select the query in the Query panel i.e the actual name of the query and copy that.
Then paste that into your spreadsheet and all your data should be imported.
So don't open the query just copy the query name.
Hope this makes sense.
Tony Bray
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
- [libreoffice-users] Re: And while I'm here, data extraction (continued)
[libreoffice-users] Re: And while I'm here, data extraction · Andreas Säger
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.