I am having a similar problem to what was posted in another thread [JRE Problem with mac os 10.11.3] and am unable to select the JRE in LO preferences as described there. There’s a lot of apparent misinformation floating around other forums on this topic. Some say you must install JDK to get the functionality needed by LibreOffice, and indicate that you have to then point to the JRE folder in /Library/Java/JavaVirtualMachines/<JDK_version>/Contents/Home/bin/java. But LibreOffice says that that folder does not contain a Java runtime environment. So that’s no help.
Other documentation focuses on the JRE itself rather than JDK. They indicate going to System Preferences and the Java Control Panel therein. I’ve done that, and have confirmed that my system has the recommended version of Java (Java 8 Update 141) installed and working. Ok, back to LO. When I go into LibreOffice/Preferences/Advanced/Java options, nothing is listed in “Java runtime environments already installed,” even though as I said, I’ve just confirmed through System Preferences that it’s there.
If I attempt to Add the JRE following the path indicated in the above thread, I can get as far as /Library/Internet Plug-ins/ and no further because JavaAppletPlugin.plugin is, well, a plugin, and it’s greyed out because it’s not a folder. I can’t navigate inside of the package to reach JavaAppletPlugin.plugin/Contents/Home/bin/java.
Anything I’m missing? I really need and want to get some things working in Base and seem to need JRE to make it happen. Ultimately I’ll be [trying to] use Spreadsheets to access Base tables, and I can’t even seem to get off square 1. Hopefully there’s some simple trick or something I’ve simply missed? Seeking help or guidance. Please, and thank you.