Apache SIS add-in installation on OpenOffice / LibreOffice

Requirements

This add-in requires OpenOffice or LibreOffice, together with Java 11 or later.

Configuration

Before installation, it may be useful to specify the Java Runtime Environment (JRE) location to OpenOffice or LibreOffice. This configuration can be done by selecting the ToolsOptions menu on Linux, or Open/LibreOfficePreferences on MacOS. In the dialog box, select Java (on OpenOffice) or Advanced (on LibreOffice). If no Java runtime environment is proposed, push the Add button and select a directory where a Java Runtime Environment is installed. When a list of JRE is available, select a Java version 11 or later.

Installation

Download the Apache SIS add-in for Open/LibreOffice and save the file in any directory. In Open/LibreOffice menus, select ToolsExtensions manager. Push the Add… button and select the downloaded apache-sis.oxt file. The installer will ask user to accept Apache 2 license and the EPSG terms of use. After installation, in may be necessary to restart Open/LibreOffice before the changes become effective. If a quick-start icon is present in the tasks bar, it should be closed before to restart Open/LibreOffice.

The add-in can be uninstalled at any time through the same menu.

Problems resolution

If Apache SIS formulas produce only #VALUE! results, if is possible that an error occurred during execution. More details can be provided by opening the jre/lib/logging.properties file with a text editor, and replace the following line:

handlers= java.util.logging.ConsoleHandler

by

handlers= java.util.logging.ConsoleHandler, java.util.logging.FileHandler

By default (it is possible to configure), a file with .log extension will be created in user’s home directory. This XML file contains information about Java program execution. Records in the org.apache.sis.openoffice logger contain information more specifically about Apache SIS ↔ Open/LibreOffice bridge. The Message element contains some details about the error cause. If you wish to ask for help on Apache SIS user mailing list, providing the messages recorded in this logger may be useful.