Apache OpenOffice Community Forum

Sorry, I've tried searching, but going through 1424 posts
is just not going to work or I am searching incorrectly.

When I start AOO, it attempts to recover my spreadsheets
from before my killing it (described further below.) It always
hangs trying to recover the last spreadsheet of 30. Is there a
way to stop it from attempting recovery of that single spreadsheet?

I have tried deleting it from its original location and the associated
.lock file. I have tried searching for similar names that might be
recovery files hidden somewhere.

It says it has recovered the other 29 spreadsheets, but I cannot
access them as all the OOCALC sheets say "Not Responding". If
OOCALC says it successfully recovered the other spreadsheets,
does that mean they are "good" in their original location or the
"good" versions are saved/hidden somewhere else - meaning if
I just don't do recovery, will I still have good versions or will
they disappear?

FWIW, this happened somewhat as it has happened to me
before, this is just the most extreme incident. I did a paste
special (HTML) to a cell which resulted in a large number of
rows and columns being added to the blank spreadsheet. I
didn't like the result so did CTRL-Z to back it out. Then I did
a paste special (unformatted).

The problem, which has bitten me before, is that when the CTRL-Z
is done, it left "a lot of" the C column highlighted instead of simply
the original single cell. So OOCALC dutifully goes marching off
trying to paste 10'000s of cells into each of the 1000's of highlighted
cells in Column C. I even let it run for 4+ hours thinking it might
finally do something, but no luck.

Is there any way to gracefully stop OOCALC in the middle of an
operation? Seems a reasonable thing to do would be to kill the
operation and revert back to the state before the attempted
operation. Tried various things, killing the process, but it always
kills everything and gets me back to the same recovery issue.

Sorry this is so long, I just cannot write "short", trying to get as
much information written as I can to reduce back and forth posts.

Thanks for any insights.

Hi and welcome to the forum!

Try to reset your OpenOffice user profile.

As for stopping Calc, no way that I know of (for any application BTW). Use the task manager to kill the soffice.bin process.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.

Thanks for the suggestion. I found another way. I had been removing the offending spreadsheet and its .lock file in the original directory which did nothing. By searching for the first characters of the spreadsheet name, I found a <name>.ods_0.ods file in the C:\Users\<username>\AppData\Roaming\OpenOffice\4\user\backup directory. I moved/renamed the file and then restarted/recovered OOCALC. It successfully recovered the other 29 spreadsheets that were open when it hung. And all is fine. Obviously, I lost any data in the "hung" spreadsheet, but after hours and hours of waiting for it to finish, it was worth it to just have it over with. It was a new spreadsheet and I had not yet entered volumes of data, thankfully. Thanks again for the response.