Hi all,
I've been searching the forum and have found some useful threads around this topic already, but haven't been able to solve my problem entirely.
I have a calc file (saved as .xls, which I'm now wishing I hadn't done) that calc cannot open. A "Text Import" dialog box comes up instead, and there doesn't appear to be anything in the file, so clearly it's having some issues. Yet I was using the file just fine yesterday. So after going through the forum, I decided to use Recuva to try to find and restore a previous version of my file. I have found a couple in ShadowCopy volumes, and have recovered those. But even those (which say they were last modified 1 month ago, almost 2 months ago) are having the same issue as the current version. Even found an old backup file in the form of filename.xls_0.ods, and that gives me a similar issue on opening, except it looks like this:
I understand why the current corrupt file might be having problems, but any ideas why the previous versions of the file I am recovering aren't able to be opened either? Again, was just editing it yesterday with no issues.
Any other remedies I might try?
Using Windows 10. Thanks.
Help recovering corrupt calc file - using Recuva
Help recovering corrupt calc file - using Recuva
Open Office 4.1 on Windows 10
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Help recovering corrupt calc file - using Recuva
Hi and welcome to the forum!
Have you tried to rename the recovered file from .ods to .zip? What you see is the beginning of a zipped file (ODF is a zip container actually).
Have you tried to rename the recovered file from .ods to .zip? What you see is the beginning of a zipped file (ODF is a zip container actually).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Re: Help recovering corrupt calc file - using Recuva
I recently had a problem caused by a brief power outage; all OpenOffice files would not open, including backups which I knew to be good. A complete restart of the computer solved the problem; I suggest, before doing anything else, that you completely restart the computer.
Edit: The clue that the problem might be with the currently active OpenOffice was that the files that would not open had their earlier dates - i.e., they had not been altered. |
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Help recovering corrupt calc file - using Recuva
A file like fred.xls_0.ods is an AutoRecovery .ods file for fred.xls. See [Tutorial] How to find and un-delete AOO temporary files for an explanation.
Please upload a file showing the problem so that it can be analysed.
Press POSTREPLY and click the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for a larger file.
That being said, any AOO file with PK not in the first two character positions in the file is almost certainly corrupted.
A valid .ods file viewed in a Hex editor
Please upload a file showing the problem so that it can be analysed.
Press POSTREPLY and click the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for a larger file.
That being said, any AOO file with PK not in the first two character positions in the file is almost certainly corrupted.
A valid .ods file viewed in a Hex editor
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Re: Help recovering corrupt calc file - using Recuva
Thanks to everyone for the quick replies!
Tried the restart, and tried changing the recovery .ods to a .zip, but it said it "could not open as a .zip".
Per @John_Ha's suggestion, uploading the recovery file for analysis.
Thanks again
Tried the restart, and tried changing the recovery .ods to a .zip, but it said it "could not open as a .zip".
Per @John_Ha's suggestion, uploading the recovery file for analysis.
Thanks again
- Attachments
-
- TotalEarnings_2020.xls_0.ods
- Recovery .ods found using Recuva (dated November 2020)
- (32.74 KiB) Downloaded 191 times
Open Office 4.1 on Windows 10
Re: Help recovering corrupt calc file - using Recuva
Edit: I didn't spot you were using UTF-8 and space as the separator - it is the same file. |
That being said it has a few lines of proper zipped .ods at the bottom but not enough to recover anything.
LO 6.4.4.2, Windows 10 Home 64 bit
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.
Remember: Always save your Writer files as .odt files. - see here for the many reasons why.