Accidentally deleted cells in spreadsheet

Discuss setup / installation issues - Add a spell checker, Language pack?

Accidentally deleted cells in spreadsheet

Postby alohamoses » Wed Jan 23, 2019 9:02 am

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?
OpenOffice 4.1.2 on Windows 10
alohamoses
 
Posts: 1
Joined: Fri Sep 09, 2016 12:19 am

Re: Accidentally deleted cells in spreadsheet

Postby robleyd » Wed Jan 23, 2019 10:09 am

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.
Cheers
David
Apache OpenOffice 4.2.0 Build 9820 alpha version - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2516
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Accidentally deleted cells in spreadsheet

Postby John_Ha » Wed Jan 23, 2019 1:30 pm

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.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6476
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 7 guests