Ask Your Question

How to link a calc spreadsheet to a base database?

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

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 close merge delete

3 answers

Sort by » oldest newest most voted

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

m.a.riosv gravatar image

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

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 ( 2014-05-17 16:21:17 +0100 )edit

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

m.a.riosv ( 2014-05-17 21:17:18 +0100 )edit

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

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 ( 2012-09-25 00:08:27 +0100 )edit

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

Simon gravatar image

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

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

edit flag offensive delete link more
Login/Signup to Answer


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

Seen: 6,390 times

Last updated: May 17 '14