Error message when attempting to work:
“No SDBC driver was found for the URL ‘sdbc:embedded:hsqldb’.”
Cannot find any installation or other documentation regarding this issue.
I don’t have a Mac, but I know on GNU/Linux, LibreOffice requires the package “libreoffice-sdbc-hsqldb”. Maybe there is something similar for Macs? Or you could switch to GNU/Linux! 
There are a couple of possibilities for this error. Go to preferences, options. Under LibreOffice->Advanced, make sure `Use a Java runtime environment is selected:
Within a few seconds there should appear Java runtime environments just below. Make sure one is selected. If none appear, the required Java is not installed. If not installed, install JDK (not JRE) from Oracle. Then re-verify setting.
If this answers your question please click on the 
(upper left area of answer).
thanks, that was helpful