Amaaazing! Thanks guys!

Two questions:
I've hit an (apparently minor) problem with locales: I tried to set up en_AU locale, which failed, and seems to have now left my locale setup in a bad state (see below). The system still seems to work, but I'd like to fix this and switch it to en_AU if possible. Any thoughts on what I've done wrong/how to fix?

!!!! My mistake: it's still necessary to set the shell environment variables to a legal language (since I had removed en_GB, the initial default to en_GB in qole's setup didn't work). Resetting the shell environment variables to sensible values now works fine.

OpenOffice 2.4 is working, and appears to allow creating text documents, presentations and drawing, but not spreadsheets (that is, they aren't listed in the File/New menu). This could be a confusion on my part - I'm more familiar with OpenOffice 3.0 beta on a mac. Are spreadsheets really missing from 2.4? Do you just create them in a different way in 2.4? Or have I screwed up my installation somehow?

!!! qole explains below how to install the spreadsheet (I guess this should have been obvious to me, I just didn't realise that it deliberately wasn't installed)

Best Wishes
Bob

Results on running dpkg-configure locales:

perl: warning: Setting locale failed.
perl: warning: Please check that your locale settings:
LANGUAGE = (unset),
LC_ALL = (unset),
LC_MESSAGES = "en_GB",
LANG = "en_GB"
are supported and installed on your system.
perl: warning: Falling back to the standard locale ("C").