Search code examples
libreoffice-calc

Data from database updating live


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.


Solution

  • 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.