Data updates do not show

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Data updates do not show

Postby happ » Sat Sep 26, 2015 4:19 pm

I used the Base wizard to create a database from my Calc spreadsheet. However, when I update the data in Calc, the updates do not show in Base. Refresh does nothing. Is there some option to make the spreadsheet changes show in Base? Thanks.
Open Office 4.1.0 on Windows 10
happ
 
Posts: 2
Joined: Sat Sep 26, 2015 4:11 pm

Re: Data updates do not show

Postby Villeroy » Sat Sep 26, 2015 8:47 pm

Restart the office suite.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24398
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Data updates do not show

Postby happ » Sun Sep 27, 2015 12:07 am

Restarting does not solve the problem.
Open Office 4.1.0 on Windows 10
happ
 
Posts: 2
Joined: Sat Sep 26, 2015 4:11 pm

Re: Data updates do not show

Postby mgroenescheij » Sun Sep 27, 2015 5:48 am

However, when I update the data in Calc, the updates do not show in Base. Refresh does nothing.
Changes in calc are only picked-up by base when you have saved it.
Is there some option to make the spreadsheet changes show in Base?
Press the refresh button on the Form Navigation toolbar.
AOO 4.1.3 on MS Windows 10
Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
mgroenescheij
Volunteer
 
Posts: 289
Joined: Thu Apr 23, 2009 10:19 pm
Location: Sydney Australia

Re: Data updates do not show

Postby Villeroy » Sun Sep 27, 2015 11:29 am

You've got to save the spreadsheet to disk and then close and reopen the database connection. Refresh buttons of all kinds fail.

What works is either one of:
1. In Writer or Calc hit F4 (data source window), right-click and close the connection.
2. Restart the office suite including the stupid "quick-starter".

Same problem with text databases (*.csv). There is no such problem with dBase. dBase has a lot more advantages over spreadsheets anyway.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 24398
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 3 guests