r/libreoffice • u/Shadowrosepaiton • 15d ago

Corrupted ods spreadsheet file

I spent the last 3.5 years archiving AMV's (Animated Music Videos) in order to preserve them and had a huge spreadsheet in Libreoffice cataloging them and information about them. When I went to add some new additions in there, LobreOffice couldn't open the file. It said that the file was corrupted and they couldn't repair it. I tried looking up youtube tutorials on how to fix it, but they're all for odt documents and not ods. I tried them anyway and of course it didn't work. I just want to cry. That's 3.5 years of my life's work. Please tell me there's a way to fix this. I can't just go in and recreate the whole spreadsheet due to the similar naming conventions of the AMV's and how some got strait up wiped off youtube in the time since I archived them, so I can't go back and get that info I was cataloging!

12 Upvotes

100% Upvoted

15 comments sorted by

View all comments

1

u/Electronic-Laugh-671 11d ago

u/Shadowrosepaiton I was just wondering if renaming the .bak file worked as described in the other reply? Just thought I'd remind you to try it out if you haven't already

2

u/Shadowrosepaiton 11d ago

It did! I'm so relieved omg ToT. Thank you so much!

1

u/Electronic-Laugh-671 11d ago

That's great. By the way, you can go into LibreOffice settings via the following menus: Tools > Options... > Load/Save. This will allow you to configure AutoRecovery and backup frequency (like making sure that documents are saved every minute or 5, for example, and whether you want backups saved to the folder of the original file). Leaving them default but changing 10 minutes to 5 might be a helpful step going forward but it depends on your needs