I'm using LibreOffice 5.1 and PostgreSQL 9.5. I need to have data from a database table available in Calc and those data in Calc should update when underlying database data change.
I've registered the database using LibreOffice Base. I don't know what to do next. I've seen this tutorial but pressing F4 does not work.
The menu command is View -> Data Sources
. On my system, the key combination in LibreOffice is Ctrl+Shift+F4, and in Apache OpenOffice it is F4.
EDIT: (in response to your comment)
The Refresh toolbar button is just for the Data Sources window. From Villeroy's instructions that you linked:
Refresh the imported range: Click a single cell in the imported range, call menu:Data>Refresh...
In LibreOffice the menu command is Data -> Refresh Range
.