4.2 LibreOffice - orbisgis/h2gis GitHub Wiki

You can use the H2 JDBC driver to connnect a H2GIS database to LibreOffice.

Step 1 : Declare the H2GIS libraries

Before you can use a the H2GIS database, you need to add all H2GIS jars to the the LibreOffice class path. Choose Tools - Options - LibreOffice - Advanced, and click the Class Path button. After you add the path information, restart LibreOffice.

Step 2 : Set the database parameters

Run the LibreOffice database wizard, select connect to JDBC, press Next button. On next panel set the JDBC URL and the H2 driver.

Go to next step and enter the user name to access the database.

You can register you database to use it with the others tools : calc, writer, impress.

At the end, set a file name to save your database.

Step 3 : Use LibreOffice