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+unsubscr...@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