Ask Your Question

How to export data from Base?

asked 2015-10-11 20:23:54 +0100

nlj gravatar image

updated 2015-10-28 03:04:46 +0100

Alex Kemp gravatar image

I'm trying to get some data out of LibreOffice Base to work with in Calc.

In attempt number 1, I created a query in Base that contains the data I want, then tried to use File | Export... to export the data. However, the Export... menu item is not present when I have the query open. When the query is closed but selected in the main Base window, the Export... menu item is there, but it is greyed out. In fact it seems _always_ to be greyed out.

In attempt number 2, I opened the query I created above and selected all the tuples/records in it. Then I did Ctrl-c to copy the selection to the clipboard. Then I went to LibreOffice Calc and did Ctrl-v to paste the data into a new spreadsheet, but the clipboard was empty -- nothing had been copied when I did Ctrl-c in Base.

In attempt number 3, I repeated the steps of attempt number 2, but I used the Copy button in Base. Again the clipboard was empty.

In attempt number 4, I tried to use File | Open command from Calc to open the database file in Calc instead of in Base. But it got opened in Base all the same.

In attempt number 5, I tried the Insert | Sheet From File command in Calc. This allowed me to select the database file, but after I clicked the Insert button, Calc promptly forgot what file I'd asked for and failed to give me a dialog to select the query the results of which I wanted imported.

I'm out of ideas. I keep hearing how much LibreOffice has been improving of late so I'm rather disappointed to find upon attempting to use it for the first time in a couple of years that it still lacks basic functionality. I'd like to help improve it, at least by providing feedback on what's not working, but I don't even know where to begin filing a bug report for this -- it seems like half a dozen things are broken in just this little use case.

[This is with LibreOffice Version: on Fedora 21 GNU/Linux with kernel 4.1.8-100.fc21.x86_64.]

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-10-28 10:18:00 +0100

updated 2015-10-28 10:19:34 +0100

Register your database and open Calc. Press F4 (data source) and choose the table or query of your database. Then drag in your Calc sheet as shown.

image description

edit flag offensive delete link more

answered 2015-10-28 01:06:06 +0100

Steve R. gravatar image

updated 2015-10-28 01:09:11 +0100

The question should be how to connect Calc to Base. I have not done that, but a quick Google search contains numerous hits. See this Q/A: How to link a calc spreadsheet to a base database?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-10-11 20:23:54 +0100

Seen: 2,201 times

Last updated: Oct 28 '15