Ask Your Question
0

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 5.4.3.2 No cell references are found in the selected cells.

edit retag flag offensive close merge delete

Comments

It seems you are referring to https://forum.openoffice.org/en/forum.... 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
0

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

Ratslinger gravatar image

Hello,

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

Stats

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

Seen: 87 times

Last updated: Dec 18 '17