How to Fix Openoffice Spreadsheet Corrupted File On MacBook

[kimngocdoan]

Hello,
I read a couple forums regarding the Openoffice spreadsheet corrupted files recovery but none is working on my MacBook. I am currently on Sierra 10.13.3. The spreadsheet when recovered through Openoffice has a few sheets deleted. Ex: spreadsheet had tabs from 2005-2019; data recovered tabs 2005-2009. Help, I can't imagine rebuilding all these years.
Thanks!!!

Ps. The file data recovery software found on the web won't let me run it unless I buy it through Apple App Store, would this even help?

[FJCC]

If you post the file here or some other place where people can access it, someone could look at the internal structure to see if the sheets can be recovered. To upload a file here, click Post Reply and look for the Upload Attachment tab just below the box where you type a response.

[John_Ha]

See [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and later) to recover previous versions of the file (is there something similar on MacOS and Linux?);

b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted;

d) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. This will recover your file as it was when you last opened or you last saved it.

[Jeff]

Hi and welcome,

It's possible to upload your file on this forum ?
How to attach a document here

Regards

[MrProgrammer]

Hi, and welcome to the forum.

The file data recovery software found on the web won't let me run it unless I buy it through Apple App Store …

Consult Apple's documentation about how to configure GateKeeper to allow non-AppStore software installation. OpenOffice is not from the AppStore and you've installed it, right?. A reminder about the process is in [Tutorial] Mac FAQ Q05/A05.

Help, I can't imagine rebuilding all these years.

Review section 6. Saving your data and making backups in Ten concepts that every Calc user should know, though it may be too late in your case. It is your responsibility to make appropriate backups of important files.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.