[Solved] Docs Have Been Zipped after using CleanMyMac

[perseids81]

My OpenOffice spreadsheet files have become zip files. Could this have anything to do with my using CLEANMYMAC Rebuild Launch Service database? How can I restore my files to their usual OpenOffice format?

[Villeroy]

OpenOffice documents ARE zip files and Microsoft OOXML documents too. Your tool removed the information that zip files with file name suffix .ods should be opened with OpenOffice.
[Tutorial] Mac FAQ, Q33

[MrProgrammer]

Hi, and welcome to the forum. I do not use CleanMyMac or any other non-Apple software to manage my Mac. Hopefully you have installed CleanMyMac from a trustworthy source.

My OpenOffice spreadsheet files have become zip files.

If you follow the instructions in [Tutorial] Mac FAQ Q52/A52 (How do I display file extensions?), you will probably find that your spreadsheets are fine, with a name like Document.ods, not Document.zip. You can use Document.ods right now from OpenOffice with File → Open. If you want to use Finder to open it, Finder needs to know what program to use. This information is managed by Launch Services on your Mac. If you've used CleanMyMac to discard that valuable information, you can reset the association between ODS documents and OpenOffice using Q33/A33. Be sure to use the Change All button, as indicated, so that you set it for all ODS documents, not just the one you've chosen.

It is possible that CleanMyMac has broken other file associations. If so, you fix them the same way, with Finder → File → Get Info, choosing the correct program, and using Change All.

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.

[Tutorial] Ten concepts that every Calc user should know

[perseids81]

Thanks for your detailed reply