Live data source.

Discuss the database features
Post Reply
Trillian3
Posts: 3
Joined: Tue Feb 14, 2017 3:56 pm

Live data source.

Post by Trillian3 »

Is it possible to link a range from a spreadsheet into a database so that it can then be linked from the data base into a new document? The link needs to be live or automatically update, like a DDE link.
 Edit: I removed your other post to avoid the conversation being split. Please don't multi post. FJCC - moderator 
 Edit: No problem, I'm new here. Trillian3 
Gotta make it work!
OpenOffice 4.1.3 Running on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Live data source.

Post by Villeroy »

You can set a refresh interval.
viewtopic.php?f=75&t=18511#p196704
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
Trillian3
Posts: 3
Joined: Tue Feb 14, 2017 3:56 pm

Re: Live data source.

Post by Trillian3 »

Excuse me, but I think the tutorial is talking about a situation where the registered data source is the data source for a table. In my project I need to be able to create a live link that will update the registered data source from a spreadsheet.
Gotta make it work!
OpenOffice 4.1.3 Running on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Live data source.

Post by Villeroy »

Spreadsheet_A --> Registered Database.odb --> Spreadsheet_B with refresh interval
not sure if it works because spreadsheets are the worst data source of all possible sources

dBase works well:
dBase_File--> Registered Database.odb --> Spreadsheet_B with refresh interval
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
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: Live data source.

Post by F3K Total »

Villeroy wrote:Spreadsheet_A --> Registered Database.odb --> Spreadsheet_B with refresh interval
works!
i set the RefreshPeriod by code for the imported databaserange.
Is there another way to define it without a macro?
R
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Live data source.

Post by Villeroy »

F3K Total wrote:
Villeroy wrote:Spreadsheet_A --> Registered Database.odb --> Spreadsheet_B with refresh interval
works!
i set the RefreshPeriod by code for the imported databaserange.
Is there another way to define it without a macro?
R
The feature has no GUI element but you can use MRI.
menu:AddOns>MRI>MRI
DatabaseRanges
getByIndex ... 0
menu:Mode>Set
RefreshPeriod ... 10
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
F3K Total
Volunteer
Posts: 1038
Joined: Fri Dec 16, 2011 8:20 pm

Re: Live data source.

Post by F3K Total »

Villeroy wrote: ...use MRI
Great, thank you!
  • MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
  • my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
Post Reply