OpenOffice Calc: Can’t save files


I’m having the strangest problem with OpenOffice Calc lately. I can create and a save a new file fine, but I can only save it once. If I then edit that same document and try to save it, I get an error:

OOCalc saving error

Can't save in Calc

I’ve tried running revdep-rebuild but it came back clean. This happens to me on the compiled and -bin versions of openoffice. I really don’t know how to fix this as I’m not sure whats wrong. I really don’t want to remerge all of openoffice’s dependencies manually.

Googling around references this error on network mounted shares, but this is just my local ext3 partition that it’s happening on. KSpread can open and write to the same exact file, so it’s got to be something picky with OpenOffice itself…

Update: Nuking my ~/.ooo3 directory fixed the issue. I’m not really sure why it was broken but I’m glad I can at least use openoffice again

,

  1. #1 by Francois on December 27, 2009 - 3:47 pm

    Could be a case of your settings being foobar. Did you try to move the $HOME/.ooo3 folder to a safe location and see what happens when you start OpenOffice.org with a fresh set of settings?

  2. #2 by Ken on December 27, 2009 - 3:55 pm

    Francois :

    Could be a case of your settings being foobar. Did you try to move the $HOME/.ooo3 folder to a safe location and see what happens when you start OpenOffice.org with a fresh set of settings?

    Yep, moving away my old settings fixed it. I didn’t really have anything configured anyway, so I guess I’ll just delete the old directory. Thanks for the hint

  3. #3 by Xake on December 27, 2009 - 4:34 pm

    I think I would either strace and try to find out where it tries to save taht “backup copy” or at least start with checking if it tries to do something in /tmp that it does not have permissions for.

  4. #4 by Francois on December 28, 2009 - 6:39 pm

    Could it just be a case of your preferences being corrupted? It can happen. Try deleting or moving .ooo3 from your home directory and start OpenOffice.org with a fresh set of preferences.

  5. #5 by Francois on December 28, 2009 - 6:40 pm

    sorry for the double post, firefox didn’t refresh the page and I thought that may be I had missed a confirmation box.

  6. #6 by Jacob Godserv on December 30, 2009 - 9:54 am

    All this guessing… if software developers learned how to spit out meaningful messages maybe these problems could be fixed rather than brute forced. :|

(will not be published)