Ask Your Question
0

connect calc to registered db [closed]

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

kasloman gravatar image

updated 2020-10-24 12:05:00 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-24 12:05:15.364363

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

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

Question Tools

1 follower

Stats

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

Seen: 446 times

Last updated: Dec 18 '17