Solved open office deleted content of my spreadsheet

April 10, 2018 at 10:03:20
Specs: Windows 10
I've been working on this spreadsheet for weeks, it is very detailed and was painstaking to do! Two separate times I have had to start completely from scratch because open office spontaneously deleted all information from my project! The file is still in my folders, but when I click to open it I am given a pop up that says for me to choose "import text" - followed by another pop up that says the document is locked for editing by unknown user & I can open a copy, or a read only. When I do this, there is no content at all. Nothing.
I have found support help to delete the ~lock files, but every time I open the document again (I keeping the files folder open), a new ~lock file automatically pops into my files and I can't see anything in the document again.
I have looked in the properties of the document & tried to restore previous version, but it says there is no previous version. It says the size is 64.1kb, so I know the content has got to be there somewhere!
Please help!! I was almost finished and do NOT want to start over :/

See More: open office deleted content of my spreadsheet

Report •

April 10, 2018 at 12:10:38
Here's a novel concept: Create a backup of the original file.

Even more novel: Create more than one backup.

Store the backups someplace other than the original location in case there is something about the original location that is causing the corruption.

Speaking of corruption, the question is why does the file keep getting corrupted? When you say that you "start completely from scratch" do you mean that you create a brand new file or that you try to "fix" the original file? If you are simply putting the data back into the original file, I suggest you stop that and really "start completely from scratch". If the original file is corrupted in such a manner that all it takes is data in a particular cell or row or column to trash the file, then you will keep having the problem.

If a brand new file still becomes corrupted, then it's time to consider the application itself as the root cause. You may want to consider starting there: reinstall Open Office. If you just want to solve your problem and not really find the root cause, then do it all at once:

1 - Reinstall Open Office
2 - Create a brand new file with no remnants from the the offending file (no copy/paste!)
3 - Store the new file in a different location
4 - Save early, save often and create backups.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Report •

April 10, 2018 at 13:02:18
I mean that I really started from scratch- I shut everything down, re-opened the program (Open Office) and started as if I had never had a project in the first place: selected spreadsheet, then "new")
I did go into open office's files & looked under the backup files that are automatically stored there, but it won't open properly either. I have saved early & often because the only other time this happened was when the program shut down before I had hit :( This time I did save & shut down the program the way you're supposed to so I was not thinking it would happen again. I understand that it is most likely a problem with the program itself. I'm thinking if I had another backup it would also not open correctly. This is why I was asking for help. I would like to correct the problem and if possible I want to restore my document up to my last save. THAT's what I was asking about.
What I've found is other people saying their open office programs are asking them for "import text" when they try to open a doc... but they are not importing any text... and that's what is happening to me.
And I have to say, it's SUPER NICE of you to suggest backing up my files after this has happened. :/ However, if you have any ideas on how to actually fix the problem, I'd very much appreciate it :)

Report •

April 10, 2018 at 17:04:55
✔ Best Answer
If I understand your response correctly, others are having the same problem as you.

If that is correct, it sure seems to indicate that the problem is the application itself. If it's the application that is causing the files to be corrupted, then I doubt you'll get an answer in a help forum such as It seems to me that the issue should be taken up with Open Office development team.

Maybe you've visited this site already, but just in case you haven't, a "bug tracker" can be found here:

Have you brought up the issue in that or another Open Office specific forum?

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Report •

Related Solutions

April 10, 2018 at 19:23:05
Have you tried to Insert the locked file into a new one?
Try this:

Open a blank file in OpenOffice.
Go to the "Insert -> File" menu
then insert your corrupted file into your new file.


Report •

April 11, 2018 at 09:42:04
"I did go into open office's files & looked under the backup files that are automatically stored there, but it won't open properly either"

Did you go directly to the folder you saved the file in (desktop, My Documents, Download, etc) & then try double clicking on it? Office will open automatically, you do NOT have to open the program to find your file.

Report •

Ask Question