User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives

Skip to content

[Solved] OpenOffice Calc vs Data Mode

Discuss the spreadsheet application
Post a reply

[Solved] OpenOffice Calc vs Data Mode

Postby Sbusy67 » Tue Nov 26, 2019 11:19 pm

Hi, I wonder if a Data Model Excel file can work in Open Office Calc by unilateral linking or much better with reciprocal linking, meaning once I update one of the files (example in Excel), the update will be reflected in the other one (OO Calc). Cheers!
Last edited by Hagar Delest on Wed Nov 27, 2019 9:11 am, edited 1 time in total.
Reason: tagged solved
OpenOffice version 4.1.7 / OS Windows 10 64-bits
Sbusy67
 
Posts: 2
Joined: Tue Nov 26, 2019 11:15 pm
Top

Re: Open Office Calc vs Data Mode

Postby Villeroy » Tue Nov 26, 2019 11:35 pm

Store data in a database. Link Ecxel and Calc to the database.
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.4
User avatar
Villeroy
Volunteer
 
Posts: 28243
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany
Top

Re: Open Office Calc vs Data Mode

Postby Sbusy67 » Wed Nov 27, 2019 1:24 am

Villeroy wrote:Store data in a database. Link Ecxel and Calc to the database.


Thanks Villeroy! Related thread at https://answers.microsoft.com/en-us/mso ... 4558790927
OpenOffice version 4.1.7 / OS Windows 10 64-bits
Sbusy67
 
Posts: 2
Joined: Tue Nov 26, 2019 11:15 pm
Top
Post a reply

Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests

Apache Software Foundation Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these
Policies and Terms of Use 		Get OpenOffice
Get OpenOffice