It seems the only way to do this is
1. Select the query name in the list of queries, and Copy
2. Paste into a new Calc spreadsheet
You cannot paste into Excel this way, and you cannot copy from the query results grid like you'd expect. Even if you select all on the results grid by clicking at top left, and Copy, only one cell gets copied to the clipboard.
NB that if you have put a filter on the query, although it will show in data table view, it will not be applied to the export.
I don't know why 'free' has to mean 'bizarre'. I'd expect copying the query name to copy the SQL source, not the output.
Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.
Quick
- ($a, $b....) = unpack("A2A7...", $packed)
- push( array, list )
