Apache OpenOffice Community Forum

Hello,

Is it possible to add data from an individual cell of a database into a text area of an impress slide?

I have a database that has 2 columns and 5 rows of data, I want to be able to update the database and when I open my Impress slideshow, the updated info in the database shows up in different text areas throughout my slideshow.

I know about using "Add OLE Object" but that just adds the complete database as a spreadsheet.. not helpful for my needs.

Thank you for any help

Bob

You mean spreadsheet cells? Copy&Paste should do the job. A spreadsheet is not a database.

I mean either calc or base, I can use either, copy and paste defeats the purpose. I am hoping to automate the process, add to the spreadsheet/database and have it automatically update in impress..

The tables in Draw/Impress can not be linked. The only thing I can think of is a grid control which draws an input form onto any kind of document. Unfortunately, OpenOffice can not handle the attached file where I tried to demonstrate it. I had to do it with LibreOffice.

Reported as https://bz.apache.org/ooo/show_bug.cgi?id=126461

Here is a macro to insert text into a presentation
http://www.experts-exchange.com/Softwar ... 03730.html

If the text could be passed from Base.... [perhaps via a string in the macro?]

This will be an interesting exercise for the long winter evenings