Comment 10 for bug 93002

Alfrednutile said on 2007-08-01: (permalink)

Still having this no wizard problem.
It works when I am using a Wizard to make a table
BUT not for Forms/Reports/Queries
Thanks

Hi Alfrednutile,

I had the same problem in Ubuntu Feisty and figured it out that the problem is caused by using the wrong java JRE with openoffice 2.2.0.

I solved this problem by installing Openoffice 2.2.1 with JRE. First I deinstalled Openoffice 2.2.0 by running the following command (you can do this in synaptic too):
sudo apt-get remove openoffice.org-core

Then I downloaded the "Openoffice 2.2.1 with JRE.tar.gz" package from openoffice.org, saved it on my harddisk in my download folder as "ooo.tar.gz". At the command line I used following commands :

sudo cp ooo.tar.gz /opt (this will copy the .tar.gz file to your /opt directory)

cd /opt

sudo tar zxvf ooo.tar.gz (this will unpack the tarball in the /opt directory)

a new directory is created in /opt, mine was named "OOF680_m18_native_packed-1_nl.9161" because I installed openoffice in dutch, if you install openoffice in english, the directory will have another name, but also beginning with "OOF680". Navigate to this directory by using the "cd" command. You will see that there's an RPMS directory. In this directory you find the Red Hat Package Manager files or RPM files. You can convert these RPM files to Debian (DEB) packages by using Alien. Use following commands :

sudo apt-get install alien (this will install the Alien package, used to convert RPM to DEB)

sudo alien *.rpm (this will convert all RPM files to DEB files)

sudo dpkg -i *.deb (this will install all DEB files in the directory)

In the same directory, there is also a directory called "desktop-migration", navigate to it. Then use the alien command again and install the deb packages :

sudo alien *.rpm

sudo dpkg -i *.deb

Now check if the java package is installed. Open Synaptic and search for "JRE". There is one package named jre (version 1.6.0-1), be sure you have the right one (if you click on the description you will see 'Converted from a rpm package by alien'). Install this package via synaptic if it is not already done.

Now start Openoffice 2.2.1 and you will see that the forms / reports / queries wizards are working.

ubuntu forever,

Kris