Gatekeeper won't let LibreOffice open .csv files I recently installed LibreOffice Vanilla (LOV) from the Mac App Store.  I want it to be the default app for opening .csv files.

First, I tried to open a .csv file using the "Open With" dialog.  LOV is not an offered option, so I clicked on "Other" and there it is but it is ghosted until I go from "Recommended Applications" to "All Applications". 

That should be it, but I then get this error message (I think from "Gatekeeper"):

If I go into Security Preferences I can make it "Open Anyway", but the next time I try to open a .csv file I get the same error.

How do I set up my Mac so double-clicking on a .csv file will have it open in LibreOffice?

Update: I found a procedure (described as an answer below) that will make LibreOffice the default app for ONE .csv file, but I have to go through the same steps (add LibreOffice to "Open With" and tell Gatekeeper to "Open Anyway") for every .csv file that has not had this done.

So how do I set up OS X so that double-clicking on any .csv file will have it open in LibreOffice?
I had the same problem and finally managed to fix it.
Simply adding 'Libreoffice Vanilla' by doing a right click on a csv file and choosing that app did not remember this for all csv files, as you state.

I was able to configure it by going to the info of a single csv file (mac button &amp; i or rightclick and 'Get Info'). Open the 'Open with' apps list and you'll probably need to choose the 'Other' option at the bottom. Choose the 'All Application' selection and 'Always Open With' option while finding the Libreoffice app in the list and confirm that selection.

Now you'll have to click the 'Change all' button right under the App selection combo box on the general file info window. This step ensured all other csv files to open using Libreoffice from then on.