Hi
I’m on Linux, Libreoffice, both the latest stable versions at time of writing.
Try as I might, I cannot work out how the simple action of copying a query result in Base to a Calc spreadsheet might work. Standard select/copy/paste actions clearly do not work.
There are no export > csv or similar I can see in BASE.
I haven’t tried doing it upside down yet, but willing to give it a go if it’ll work. Unless you might have a better, easier suggestion. A magic spell or action, maybe?
Thanks
Hello,
First your Base file needs to be registered.
.
With that, in Calc, from menu select View->Data sources ( or Shift+Ctrl+F4). Data in left pane is registered Base files. Click on arrow left of Base registered name. Now you have tables & queries. Expand Queries with click on arrow and click on wanted query. Result in right pane.
.
Can drag/drop onto sheet what is wanted.
.
For more info → LibreOffice 7.3 Help and search for data sources
.
Registering → Registering and Deleting a Database
Hmmm … the database is registered, or at at least appears to be under Tools.
The database appears under Calc > View > Data but after connecting to it (open tables list) the queries I have saved in the database are not listed.
Using a remote mysql DB.
But thanks for trying
Should always note DB used. Do not have access to a remote MySQL DB but my local MySQL server has no issue with Queries or tables.
’
You should verify the registered database.
@Arskin
.
Another option. Open your Base file & run the Query. Click on Upper left corner (blank left of field names). Will highlight all items. Right mouse click same cell & select copy. Then paste in Calc:
Thanks, but that only works in WIndows for me, not Linux (Mint). The clipboard remains empty after initiating copy.
Basically, that started this conversation; I used Windows/ Libreoffice last week and the standard copy/past worked fine. Yesterday went back to mint, where it did not work.
My test was using Ubuntu 20.04
.
Not certain about Mint. Will go test. You also have not stated what LO version you are using. Mine:
Version: 7.3.0.3 / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Do not have MySQL ready on Mint 20. Went to Mint 19.3 with LO v7.1.0.3 and copy did not work. Suspect possibly LO version, but that is just a guess. Did not test with different version.
.
However, drag & drop worked. Highlighted query result in Base as noted earlier and dragged to Calc sheet. Worked. Needed some column width mods. Not not spend much time with it.
Mysql is 5.7 on remote linux server.
See my solution below; the issue seems to have been something not working in Libreoffice - apt remove did not help, but apt purge did.
sudo apt purge libreoffice*
sudo autoclean && sudo autoremove -y && sudo update
sudo apt install libreoffice*
All good, copy query result rows, paste to calc spreadsheet now works as expected.
Cheers
This most likely installed a different version. Deleting & re-installing the same version in most cases is of no help. The method for same version fixes is to reset the user profile → LibreOffice user profile