English
Ask Your Question
0

How to link a calc spreadsheet to a base database?

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?

Regards

edit retag flag offensive close merge delete

3 answers

Sort by » oldest newest most voted
1

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

mariosv 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

Comments

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

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

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

mariosv ( 2014-05-17 21:17:18 +0200 )edit
0

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

Rod gravatar image

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

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

edit flag offensive delete link more

Comments

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

mariosv ( 2012-09-25 00:08:27 +0200 )edit
0

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
Login/Signup to Answer

Stats

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

Seen: 4,863 times

Last updated: May 17