Ask Your Question

How to link a calc spreadsheet to a base database? [closed]

asked 2012-09-20 23:04:32 +0200

Simon gravatar image

I would like to have a calc spreadsheet that feeds off information/data in a base database. Then when the database is updated, this in turn will update the spreadsheet information after a "refreash". Is this possible in libreoffice? if so where is the documentation / howto?


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 2016-02-23 02:11:34.043454

3 Answers

Sort by » oldest newest most voted

answered 2012-09-21 02:00:43 +0200

m.a.riosv gravatar image

updated 2014-05-17 21:16:05 +0200

Here you can find a detailed explanation:

Tutorial - Using registered datasources in Calc

201405167 - edited the link

edit flag offensive delete link more


could you post another link because I can't access this one, please!

thadeus.tiderle gravatar imagethadeus.tiderle ( 2014-05-17 16:21:17 +0200 )edit

Edited, I think there was changes in the openoffice forum url, please try again.

m.a.riosv gravatar imagem.a.riosv ( 2014-05-17 21:17:18 +0200 )edit

In LibreOffice I had to use Ctrl+Shift+F4, not F4 as the referenced OpenOffice tutorial says as does However, Menu->View Data Sources does work as the latter says. Thanks!

Amooti gravatar imageAmooti ( 2018-10-18 15:09:44 +0200 )edit

answered 2012-09-21 01:10:45 +0200

Rod gravatar image

I think it is from Insert --> Link to external data.

Unfortunately appears to have a bug since it stops working when I attempt to do the link

edit flag offensive delete link more



I you are trying to link with Base, this is not the right way, follow the link on my first answer.

m.a.riosv gravatar imagem.a.riosv ( 2012-09-25 00:08:27 +0200 )edit

answered 2012-09-24 13:49:12 +0200

Simon gravatar image

updated 2012-09-24 13:53:29 +0200

Thank you for the tutorial, I see that it works.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-09-20 23:04:32 +0200

Seen: 30,791 times

Last updated: May 17 '14