I find it suits most of my needs on a day to day basis but can struggle in certain areas. Advanced calculations in xls or libre typically do not translate well if exporting/opening from one to the other.
Here are a few cons of libre calc
- Macros in excel are VBA (libre cannot understand complex VBA macro)
- More advanced chart type options
- No NATIVE real time collaboration (third party)
- Power Query and Power Pivot are amazing for large data sets and Libre has no way to do something similar (that i know of).
I am able to do most if not all normal office functions otherwise. The Libre Draw does misinterpret some pdfs with odd symbols which can be annoying. For a small legal business it should work fine with just the occasional quirk needing some tweaking since they do some things differently.