Ask Your Question

Recover previous version of calc spreadsheet? ("Always create backup copy" enabled) [closed]

asked 2017-06-27 11:58:47 +0200

appreciatethehelp gravatar image

updated 2017-06-27 11:59:31 +0200

Hey guys. I know there are similar questions to this one but I found many of them to be a bit convoluted, so I thought I'd start a fresh question.

I just want instructions regarding the recovery of the previous version of my spreadsheet. As the title suggests, "always create backup copy" is enabled, so I just need to know how to retrieve the backup.

I am running version on OSX lion, if that matters.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-07-18 18:58:22.835081

1 Answer

Sort by » oldest newest most voted

answered 2017-06-27 12:32:20 +0200

robleyd gravatar image

updated 2017-06-28 01:32:38 +0200

Look in the directory set as your backup directory in LibreOffice | Options | LibreOffice | Paths (I think that is where it is on a Mac) for a file the same name as the file to recover, but with a .bak extension.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

UPDATE: You may find this Mac FAQ useful for LO related things.

edit flag offensive delete link more


I can't seem to find the backup directory, I can't even find a "libreoffice" file other than the actual application itself. Therefore I can't access the "options" section as you advised.

Have tried a spotlight search, as well as searching the Hard Drive. The only things that come up are libreoffice documents I have made and the application itself. Not sure where to go to find the "options" folder...

appreciatethehelp gravatar imageappreciatethehelp ( 2017-06-27 13:02:06 +0200 )edit

On MacOSX it's not the menu Tools -> Options but File -> Preferences or some such. Within the application of course.. and in that Options/Preferences dialog there's LibreOffice -> Paths from which you take the backup path.

erAck gravatar imageerAck ( 2017-06-27 14:10:26 +0200 )edit

Thanks for the input. I only assumed the backup folder was stored separately from the application due to previous experience with other applications. Could someone please confirm the path to reach the "options/preferences dialog"? It isn't through file > preferences...

appreciatethehelp gravatar imageappreciatethehelp ( 2017-06-27 14:34:25 +0200 )edit

First hit if you start to type tools options into the search bar here.. LibreOffice -> Preferences.

erAck gravatar imageerAck ( 2017-06-27 17:29:50 +0200 )edit

Question Tools

1 follower


Asked: 2017-06-27 11:58:47 +0200

Seen: 224 times

Last updated: Jun 28 '17