Restore previous version of calc file?

[Nerves1]

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: 4.3.7.2
OSX 10.9.5

[AlexKemp]

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 ().

[Nerves1]

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.

[ROSt53]

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

[Nerves1]

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