Ask Your Question

I accidentally filled an entire column with a formula and clicked save in Calc - LibreOffice subsequently crashed and has been unable to open my document since - How would I go about recovering my document? [closed]

asked 2013-07-13 15:55:31 +0100

Hwciua4i gravatar image

updated 2015-11-03 23:06:14 +0100

Alex Kemp gravatar image

The formula was a simple "this column - this column" formula and thus the column is filled with mostly 0s and I only need the data up to say 200 rows.

I'm assuming that Libre is unable to load the spreadsheet because the number of rows is not capped at a certain amount and so I've accidentally created a tremendously large document.

How would I go about getting this document to open? Or at least open up to 200 rows or something?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 23:06:43.208390


Please what is your OS and your LIbreOffice version?. Had enabled the options for backup and recovery in Menu/Tools/Options/Load-Save/General?

m.a.riosv gravatar imagem.a.riosv ( 2013-07-13 17:16:48 +0100 )edit

Hi, thanks for the response, the LibreOffice version is Version (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) and my OS is Win 7 Professional 64 bit Service Pack 1 the options in the Load-Save/General are set to their default I believe, and so "always create backup copy is unticked"

Hwciua4i gravatar imageHwciua4i ( 2013-07-14 03:20:11 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-07-14 12:30:19 +0100

m.a.riosv gravatar image
edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-07-13 15:55:31 +0100

Seen: 325 times

Last updated: Jul 14 '13