Openoffice - Staroffice

From Wiki

Oxygen Office

A recompilation of the standard openffice package. Vastly fitted with extensions. A lot of bugs fixed. So just use it!


--Apos 16:29, 12 January 2012 (CET) In newer Openoffice versions some functionality was moved to extensions. They can be mound here:

The older links are not working any more!

Mediawiki export

--Apos 17:54, 12 January 2012 (CET) To make it short: use oxygen office, which is an openoffice recompile and just works.

Export ODT out of Mediawiki

Use the default packages

There might be some problems using the distributions packages, so I recommend installing the original from their website.


Ubuntu jaunty / 9.04

[UPDATE] Openoffice 3.1 and ubuntu jaunty (9.04)

The new way of using the very actual version of openoffice in ubuntu is to use the appropriate PPA archive in the /etc/apt/sources.list file:

# Openofffice
deb jaunty main #Open Office (ppa)
#deb-src jaunty main

After an

apt-get update && apt-get upgrade

you should have a working and updated office.

The german language package (for oo 3.1) had to be installed separately from the following link:


Older Ubuntu Versions

I like to use the official packages of openoffice due to a mixed computer environment. This is the only way to assure same funcitonality and certification. But I run into trouble doing this.


Download the packages from and extract them into a directory. The package names may vary to depending to your version and download:

tar xzvf OOo_2.3.0_LinuxIntel_install_de_deb.tar.gz
cd OOG680_m5_native_packed-1_de.9221

Naturally, if I like to install the packages provided by in ubuntu/debian via dpkg, i get an error:

# dpkg -i*
dpkg - warning: downgrading from 1:2.3.0-1ubuntu2 to 2.3.0-5.
dpkg: regarding containing conflicts with

Remove distribution packages

That's why I have to uninstall the ubuntu openoffice org packages:

# apt-get remove
The following packages will be REMOVED: python-uno
0 upgraded, 0 newly installed, 20 to remove and 2 not upgraded.
After unpacking 275MB disk space will be freed.
Do you want to continue [Y/n]? Y

I am than able to install the packages:

# dpkg -i*
Selecting previously deselected package
(Reading database ... 316754 files and directories currently installed.)
Unpacking (from ...
Selecting previously deselected package
Unpacking (from ...

Configure apt for unattended upgrades

If I then upgrade my machine, ubuntu tries to uninstall my openoffice packages and upgrades them to the distribution ones.

So I have to manually edit the /etc/apt/apt.conf.d/50unattended-upgrades. Add the part Unattended-Upgrade::Package-Blacklist followed by a list of packages - one per line. This list is surrounded by {...}-brackets. Don't forget the quotation marks around the package name and the semicolon (;) at the end of each line.

Unattended-Upgrade::Package-Blacklist {
//      "package_with_is_commented_out";

Let's do it:

vim /etc/apt/apt.conf.d/50unattended-upgrades

// allowed (origin, archive) pairs
Unattended-Upgrade::Allowed-Origins {
        "Ubuntu gutsy-security";
//      "Ubuntu gutsy-updates";

// never update the packages in this list
Unattended-Upgrade::Package-Blacklist {
//      "vim";

Test it

When I then try to update, the system won't bother any more:

# apt-get upgrade
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages have been kept back:


You can use this to hinder ubuntu/debian from automatic kernel updates ;)


Distribution upgrates

If you are going to make a distribution upgrade, it might happen, that ubuntu uninstalls the packages. You have to install them again.

Automation of OpenOffice and Java

Some Links

(some in german language)



(1) Password saved - for private use only. Do not download without permission, crack, copy or (re)distribute.

Develop with Netbeans

Best for developing java applications for openoffice is with sun's netbeans. The openoffice plugin - accessible via the update function of netbeans - is the fastest way to get ready.

Increasing the fontsize

Add the following to the /netbeans_install_dir/etc/netbeans.conf

netbeans_default_options="  [...] fontsize 14"

Postgresql and Openoffice

According to PostgreSQL-Datenbanken in 2.0 unter Linux.

This applies an is tested for ubuntu gutsy, Hardy.

Openoffice <-> JDBC

1. Java settings

Install the corresponding version of the jdbc jar file in the classpath of your oo java settings (extras). the *jdbc3 works fine with java 1.5.

There are problems with java 1.6 and the according *jdbc4.jar. So be shure to use java 1.5.

  • e.g. postgresql-8.2-506.jdbc3.jar, /usr/share/java/postgresql-jdbc3-8.2.jar, ...

2. Connection

In the settings wizard of openoffice use ...

  • jdbc:postgresql: [ //servername [:port/] ] databasename
  • org.postgresql.Driver

... for the connection settings.

3. Change the database in an existing oo form

  • Open the form file.
  • Go to Edit->Database->Connection Type.
  • On the second screen you can change the server settings.

Openoffice <-> ODBC

For connection between openoffice and odebc:

apt-cache search odbc | grep unix
   unixodbc - ODBC tools libraries
   unixodbc-bin - Graphical tools for ODBC management and browsing

apt-get install unixodbc unixodbc-bin

With the command ODBCConfig you can manage the configuration files (part of the package unixodbc-bin). Start it as superuser with gksu or use it to manage your local database configuration files - stored in your home directory.

But for nowe, we will - later - edit the configuration files by ourself.

ODBC <-> Postgresql

For connection between the odbc layer and the database:

apt-cache search odbc
   odbc-postgresql - ODBC driver for PostgreSQL

apt-get install odbc-postgresql

Configuration files

Ubuntu installs its odbc libraries in /usr/lib/odbc. There are two versions of the postgres odbc driver: an ascii version ( and a unicode version ( We are using the latter.

vim /etc/odbcinst.ini
Description = PostgreSQL ODBC Driver
Driver = /usr/lib/odbc/
Setup = /usr/lib/odbc/

For system wide database location you have to edit the /etc/odbc.ini file.

There is a section Driver. You have to insert exactly the same name as defined in the odbcinst.ini between the braces, e.g. use PostgreSQL, if your odbcinst.ini is defined as [PostgreSQL]:

vim /etc/odbc.ini
Description = PostgreSQL Test Database
Driver = PostgreSQL
Servername = localhost
Database = pgtest
Port = 5432
ReadOnly = No

Establish connection

If you like to connect to an database via openoffice you should use a string like:


Don't forget to allow connections in /etc/postgresql/8.2/main/pg_hba.conf (see above) to your database server!

The rest is really self explanatory within the openoffice database assistant ;)