Data updates do not show
Data updates do not show
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
Re: Data updates do not show
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 300
- Joined: Thu Apr 23, 2009 10:19 pm
- Location: Sydney Australia
Re: Data updates do not show
Changes in calc are only picked-up by base when you have saved it.However, when I update the data in Calc, the updates do not show in Base. Refresh does nothing.
Press the refresh button on the Form Navigation toolbar.Is there some option to make the spreadsheet changes show in Base?
AOO 4.1.5 on MS Windows 10 Professional & MacOS High Sierra 10.13.5
Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
Please add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.
Re: Data updates do not show
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.
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 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice