Spell Check with Open Office 2.4 on Ubuntu 8.04

Apparently Open Office on Hardy Heron doesn’t come with Spell Check support out of the box. To enable it, you need to follow the following steps.

1. Open up Open Office Writer and goto the menu item “Install New Dictionaries” in File>Wizards.
2. A Read-Only File with text links to various languages opens. You will want to click on ‘English’

3. In the page that is displayed click on the button “Start DictOOo”
4. A dialog opens. (In case you are not able to view the windows fully, goto the Gnome Menu item “Appearance” in System>Preferences and set the Visual Effects to None to disable Compiz. Do once again from step 1.)

5. Click ‘Next’ Once and in the next screen, click on the button “Retrieve the List”. Open Office will connect to the dictionaries server and retrieve a list of dictionaries available. You are serially allowed to select the needed a) Spell Checker dictionaries in the first windows, b) The Hyphenation Dictionaries in the next window and finally the c) Thesarus Dictionaries.

6. Click Next Once while it downloads and displays information on the files to be installed. Click Next Once again for it to finally install the selected dictionaries.

That is possibly all you need to do to setup your dictionaries. Now go to the Open Office Menu, “Tools> Options”, Expand the “Language Settings” Section, select “Languages” and set “Default Language for Documents: Western” to English (USA) or English (UK).

When you select a language, if it has a tick mark with ‘ABC’ written to the left of the name of the language, the Dictionary for that language is installed. English(India) apparently doesn’t have a dictionary that can be downloaded yet.

Hope this helps. Let me know if the post was useful

Connecting to a MySQL Database from Open Office Base – Errors

While trying to connect to a MySQL Database from Open Office base, you might get the ‘JDBC Driver could not be loaded error’

On Clicking the Test Class Button

It is actually pretty simple to solve.

Download the MySQL Connector jar file from mysql.com and save it to your desktop. You now get the file mysql-connector-java-5.0.8.tar.gz on the desktop

Open up a terminal and try unzipping the file after navigating to the Desktop
sudo tar -xvvzf mysql-connector-java-5.0.8.tar.gz

The tar command unzips the file and creates a directory named mysql-connector-java-5.0.8. Open the folder and you will find the file mysql-connector-java-5.0.8-bin.jar

That is actually the only file we are interested in. Move that file to the external libraries directory for your java runtime environment as below (you may have the modify for your actual runtime version.)
From the Desktop:
sudo mv mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar /usr/lib/jvm/java-1.5.0-sun-

The JDBC Connector now works properly

Note: If this doesn’t work, make sure that the correct JVM is selected for Open Office in Tools>Options in any of the Open-Office Applications.