OpenOffice misfunction in LibraNet

[hilltownboy]

Very happy using LibraNet 2.8.1 for over two years but now my OpenOffice spreadsheets, whether existing ones or new ones, refuse to be saved. Instead a notice appears: "an unrecoverable error has occurred". It seems that the spreadsheet goes into a .tmp file that can sometimes be recovered but not saved in the normal way. This does not happen with other OO files such as documents or Impress; they still save normally. Can anyone explain the LibraNet arrangement of OO and/or point to what part of it may be causing this error?

[AndreL]

I've had this problem with the OoO 2.x "backport"... Are you using that?

[hilltownboy]

No, I am using OOo 1.0.3 and I haven't yet figured out what "backport" is.

[bhobjj]

If you want to try to keep your version of OpenOffice and fix what is broken, you need to know if the problem is system-wide or just for some user settings. Try logging in as a different user and see if you still have the problems with the spreadsheet program.

If the problem is system-wide, you could try to reconfigure OpenOffice:
# dpkg-reconfigure openoffice.org

If you have the bandwidth (120MB), you could download the latest version of Openoffice from http://download.openoffice.org/2.0.3/contribute.html?product=OpenOffice.org&os=linuxintel&lang=en&version=2.0.3 It should work OK with your system.

[hilltownboy]

Thank you, bhobjj: logging in as a different user lets me run my spreadsheets properly. Detecting what's wrong with the original user setting looks like a bit of a challenge.

[bhobjj]

Thank you, bhobjj: logging in as a different user lets me run my spreadsheets properly. Detecting what's wrong with the original user setting looks like a bit of a challenge.

I don't have that version of OpenOffice installed, but the original user's settings are probably in a hidden directory.

You could try renaming the directory and then when you start Openoffice, it will be rebuilt. Do this when openoffice is not running.

In a shell:
see if such a directory exists
$ ls .openoffice
If it does, then rename it:
$b mv .openoffice .old-openoffice

When you start openoffice, it should recreate the .openoffice directory with default settings. If this proceedure dosen't work, you can always rename the old directory back to the original name.