Ask Your Question

connect calc to registered db

asked 2017-12-18 22:38:35 +0200

kasloman gravatar image

Hi, I've created a MySql database and then used LOBase to connect to it. It shows the tables correctly. How can I connect a LOcalc sheet to this registered db?.

One site , [Tutorial] Using registered datasources in Calc, I visited says: "In Calc hit F4, browse your database and drag the table (or a query for the same purpose) from the left pane onto a cell."* Pressing F4 puts up a box saying LibreOffice No cell references are found in the selected cells.

edit retag flag offensive close merge delete


It seems you are referring to That would have been good to mention in the question. On that page, Romke states, "In newer version of LO the key is changed from F4 to Ctrl+Shift +F4" (Oct 27, 2016).

Jim K gravatar imageJim K ( 2017-12-19 06:07:15 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-12-18 23:10:39 +0200

Ratslinger gravatar image


The correct key combination is Ctrl + Shift + F4. This is also accessible from menu View->Data Sources.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-12-18 22:38:35 +0200

Seen: 334 times

Last updated: Dec 18 '17