Ask Your Question

Restore previous version of calc file? [closed]

asked 2015-07-29 18:21:59 +0200

Nerves gravatar image

updated 2020-08-23 09:52:59 +0200

Alex Kemp gravatar image

I had a spreadsheet open that I'd been working on and took a break to look at something else while still at my desk. When I returned to the sheet it was blank. I had over 6,500 rows and seven columns. My cat did walk over part of my keyboard but I don't see how that could've cleared the entire sheet and besides another application was on top when she did it. There are two other sheets in the file but they are fine. I had it mirrored with bitcasa but they presently don't have a previous version feature. The last time I ran time machine was six months ago so I've lost over 1,000 rows of entries and lots of editing. Is there any way to recover earlier versions of the file? I didn't have the back up copy feature enabled in calc.

LO Version: OSX 10.9.5

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-13 13:45:01.171833

2 Answers

Sort by » oldest newest most voted

answered 2015-07-29 19:35:17 +0200

Alex Kemp gravatar image

Didn't you try the Undo facility (Ctrl-Z)?

At one point in my life I got paranoid about losing work after some arsehole action on my part & several days' work lost. So, I bought a 2nd hdd & got into the habit of making complete backups to that disk. Boy, did I think I was smart. 8 months later I had a burglary & they stole the whole computer. Including both hdd. I had zero external storage.

If this helps then please tick the answer (✔).

edit flag offensive delete link more


Unfortunately that wasn't an option. Fortunately I had another version of the sheet on googledocs except that it's missing three columns of personal data that I'll have to re-enter. Yeah, but from now on I'm going to back it up in several places.

Nerves gravatar imageNerves ( 2015-07-29 21:06:58 +0200 )edit

answered 2015-07-30 11:36:02 +0200

ROSt52 gravatar image

For this time it is too late. I recommend, and do it myself, to save files daily new with a the actual date in the file name. This reduces the maximum loss to 24h. Filename format: filename_yymmdd.extension

edit flag offensive delete link more


Thanks. Well I've decided to keep time machine on all the time which backs up incremental changes every hour.

Nerves gravatar imageNerves ( 2015-07-30 16:51:43 +0200 )edit

Question Tools

1 follower


Asked: 2015-07-29 18:21:59 +0200

Seen: 363 times

Last updated: Jul 30 '15