RE: Possible to have common data-table, sync across LO ?

Discuss the word processor

RE: Possible to have common data-table, sync across LO ?

Postby sparxz » Fri Feb 01, 2019 2:02 pm

Is it possible to have common a data table, to have synchronized across Modules of LibreOffice.

Eg I am writing a Presentation in Presenter, and I am writing a separate detailed document, based on a Table in the Slides.
It would make things a lot easier if I could make one table instead of two, as Copy and past from Presenter to Writer,
does not work well, either copy past table, or even manually each cell.

I thought Base, give a back end to store data for purposes like this ?

Thanks.
OpenOffice 2.4 on Ubuntu 9.04
sparxz
 
Posts: 3
Joined: Fri Feb 01, 2019 1:33 pm

Re: RE: Possible to have common data-table, sync across LO ?

Postby Villeroy » Fri Feb 01, 2019 2:42 pm

You can open the data source window in Impress. If the command is not availlable, you can add it via Tools>Customize.
The data source window shows registered databases with their tables and queries. You can drag any table's or querie's icon from the data source window into a text document, spreadsheet, drawing or presentation. This will insert a copy of data or some kind of link depending on the type of document.
You may also open the respective Base document and copy/paste the icon of a table or query from the Base document window.
There is no way to link the data tables in Impress. They always contain copied snapshots. However, presentations can have input forms as in viewtopic.php?t=78650&p=360532#p360532

Base can create a database with the actual database embedded in the Base document but this is not what most people need.
A Base document does not contain any data if it is connected to some kind of true database or pseudo-database (text files, dBase files, spreadsheet).

File>New>Database...
Connect to existing database
Type: whatever you have
[X] register database (normally yes)
Save database
Add meaningful queries
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27112
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: RE: Possible to have common data-table, sync across LO ?

Postby robleyd » Sat Feb 02, 2019 12:58 am

Note; cross posted to AskLibreOffice
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2949
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: RE: Possible to have common data-table, sync across LO ?

Postby sparxz » Thu Mar 14, 2019 7:14 am

Thanks. I am leaning a lot !
OpenOffice 2.4 on Ubuntu 9.04
sparxz
 
Posts: 3
Joined: Fri Feb 01, 2019 1:33 pm


Return to Writer

Who is online

Users browsing this forum: No registered users and 22 guests