Page 1 of 1

Data updates do not show

PostPosted: Sat Sep 26, 2015 4:19 pm
by happ
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.

Re: Data updates do not show

PostPosted: Sat Sep 26, 2015 8:47 pm
by Villeroy
Restart the office suite.

Re: Data updates do not show

PostPosted: Sun Sep 27, 2015 12:07 am
by happ
Restarting does not solve the problem.

Re: Data updates do not show

PostPosted: Sun Sep 27, 2015 5:48 am
by mgroenescheij
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.

Re: Data updates do not show

PostPosted: Sun Sep 27, 2015 11:29 am
by Villeroy
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.