Page 1 of 1

Accidentally deleted cells in spreadsheet

Posted: Wed Jan 23, 2019 9:02 am
by alohamoses
Last Saturday evening I apparently deleted some cells in my Open Office spreadsheet. I mistakenly thought I had copied and pasted the data elsewhere when I selected 5 pages of data, clicked on "EDIT" then clicked "DELETE CELLS". I backed up the file and went away for the weekend. When I came into work today, I could not find my data. Is there a way to retrieve it?

Re: Accidentally deleted cells in spreadsheet

Posted: Wed Jan 23, 2019 10:09 am
by robleyd
Your only hope - [Tutorial] How to find and un-delete AOO temporary files You may be lucky enough to recover something.

I assume you don't have a series of backups; perhaps consider installing and using the Time stamped backup extension.

Re: Accidentally deleted cells in spreadsheet

Posted: Wed Jan 23, 2019 1:30 pm
by John_Ha
If you opened a saved file, or if you created a new file, and you then added some date, and you then deleted that data, it is gone forever unless an AutoSave took place during which the data was captured.

If the data was in a saved file, and you opened that file and deleted the data, follow the Tutorial.