Apache OpenOffice Community Forum

How do I recover a previous version of a spreadsheet file?

Get it from the daily backup you take. Ah! You don't backup your files ...

You can get a backup if you went Tools > Options > Load/Save > General ..., and ticked Always create backup copy. Ah! You didn't do that ...

See [Tutorial] How to find and un-delete AOO temporary files for

a) detailed instructions on how to recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

b) how to find previous versions of the file in the folder it is located in, but which have since been deleted;

c) how to un-delete the temporary files AOO wrote while you were editing the file, and then deleted. This will recover your file as it was when you last opened or you last saved it.

You will find much useful information in the User Guides, the Writer, Base and Calc Tutorials and the AOO Frequently Asked Questions. May I suggest you bookmark the pages.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.

Your operating system lets you set up saving of backup files and versions of files. You can probably find instructions already posted on a Windows forum.