Re: [libreoffice-users] And while I'm here, data extraction

Thanks all.

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.

To be clear selecting all the data in the result and pressing ^C (or 
selecting "Copy" from the edit menu) then selecting a blank Calc 
spreadsheet and pressing ^V (or selecting "Paste" from the edit menu) 
doesn't produce any data whatsoever in the spreadsheet.  I little 
experimentation has shown me that selecting either a complete column 
or a single cell in the result set, pressing ^C and then pressing ^V 
in the spreadsheet *both* give me a single cell output to the 
spreadsheet.

Something does seem to be copying into the spreadsheet. Trying to past 
multiple cells like this clears the previous contents of the cell but 
there is nothing to see. Saving the sheet, which looks empty, produces 
a file of 10.2kb where saving an a truly empty sheet is 10.1kb.

Is there some setting I've miss-set?

<Stope Press> Pasting a small table (35 rows five cols) works, 
although, strangely, it brings in an extra row for column names. Not 
much use bringing in a table. That's what we need databases for in the 
first place, to manipulate tables to produce results.

Having said all of that, is it ideal that the only way to get a data 
output from Base is C'n'P?

Mark



-- 
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