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
Adding database cell into impress
Adding database cell into impress
Open Office 4 On Windows 10.1
Re: Adding database cell into impress
You mean spreadsheet cells? Copy&Paste should do the job. A spreadsheet is not a database.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Adding database cell into impress
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..
Open Office 4 On Windows 10.1
Re: Adding database cell into 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
Reported as https://bz.apache.org/ooo/show_bug.cgi?id=126461
- Attachments
-
- form_grid.odp
- presentation with "biblio.dbf" form grid
- (11.01 KiB) Downloaded 378 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Adding database cell into impress
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
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
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS