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
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
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
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
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