Ask Your Question

Registering a spreadsheet as a data source

asked 2018-01-27 20:02:07 +0100

quorlia gravatar image

updated 2018-01-27 20:03:12 +0100

I have a spreadsheet saved as sheet.ods. I want to use this as a data source in a writer file (specifically with Basic Report Extension). I had this working on my old computer which I think was using an older version of LibreOffice but when I go to Tools>Options>Base>Databases it will only let me search for ODF files so I can't add it. And I can't see an option in the Save As menu in Calc to save the spreadsheet as sheet.odf. My current version is on Ubuntu 16.04.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-01-27 21:44:04 +0100

Ratslinger gravatar image


Only databases are registered. You must first create a Base file connected to the spreadsheet data. Please see answer in this post.

edit flag offensive delete link more

answered 2018-01-28 19:59:45 +0100

quorlia gravatar image

Thanks. Should updating the spreadsheet be reflected in the base file now? I could only get my report to generate using data that was in the spreadsheet when the base file was created. I need to keep adding to the spreadsheet so will I need to add in an extra step of opening the base file before generating my report? Or is there some option I need to check that I haven't?

edit flag offensive delete link more


@quorlia First, you are welcome. Second, please do not post responses as answers. Instead use comment for answer you are responding to. Answers are to respond to original question.

In answer to latest question you will get updated info in base depending. With Writer, if data sources is opened, WYSIWYG. Now with writer closed, if the data in Calc linked to Base is a Named Range, you must change that range to reflect in Base. Testing seems to reflect the need to re-open Base to get changes.

Ratslinger gravatar imageRatslinger ( 2018-01-28 20:30:28 +0100 )edit

Sorry. Thanks for putting me straight on using the board. And thanks for the quick response. At least I know what's going on now.

quorlia gravatar imagequorlia ( 2018-01-29 15:01:13 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-27 20:02:07 +0100

Seen: 53 times

Last updated: Jan 28