Ask Your Question

libreoffice-base: add tables in query design not allowed

asked 2017-03-13 19:16:41 +0200

cirripede gravatar image

updated 2017-03-13 20:56:11 +0200

Libreoffice-base: add tables in query design not allowed. In query design, no more than one table can be added (F7 does not work and the add-tables icon becomes dimmed after the first table added in query design) This is true both for version and on xubuntu 16.04

Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc CPU Threads: 4; OS Version: Linux 3.13; UI Render: default; VCL: gtk2; Locale: en-GB (en_US.UTF-8); Calc: group

Other versions and OS not tested. Not found answers for this abnormal behaviour.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-03-13 19:31:45 +0200

Ratslinger gravatar image

updated 2017-03-13 22:38:30 +0200

I do not see any problem adding multiple tables in queries. Have done this on LO versions from 4.x through 5.3.x using a variety of Linux distros including Xubuntu 16.04.

Where did you get your LO from? The distro? This on rare occasion is the cause of some problems. Is this a regular embedded DB?

There may also be a problem with you user profile being corrupted. See this post to clear - click here.

Edit: I see you have modified your question but never answered the questions I have asked.

I believe I have discovered what you are talking about. You have created a Base file using a spreadsheet. If so, this is nothing more than a linkage to the spreadsheet data. There are no TRUE tables and therefore you have only one access in the Query. You also cannot change the data from Base.

To utilize multiple groups of data, create a true database from the data in the Calc document. See the documentation on how to accomplish this - click here.

edit flag offensive delete link more


See my answer to my question. I wrote there instead of here. Thank you again.

cirripede gravatar imagecirripede ( 2017-03-13 22:59:36 +0200 )edit

If this answers your question please click on the ✔ (upper left area of answer).

Ratslinger gravatar imageRatslinger ( 2017-03-13 23:12:29 +0200 )edit

answered 2017-03-13 22:56:46 +0200

cirripede gravatar image


You are right. I tried to create a query on a linked spreadsheet. I thought it was possible since it was a SELECT read-only query. After your first version of your answer I tried with embedded tables created by importing data from the spreadsheet instead of just linking the spreadsheet. It worked. Now I read your edited note and that was it.

As for my previous modification of the question, it was only punctuation changes. Nothing relevant. And I made them before seeing your answer. That is why I answer only now.

Thank you for your help. Your hint about the embedded DB was crucial.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-03-13 19:16:41 +0200

Seen: 166 times

Last updated: Mar 13 '17