Con is that calc is so broken. At first, I thought it was just me. But even our accountants were quietly building spreadsheets in Google Sheets and then "pretending" like they use Calc.
There is one thing I use Libre Calc over Excel for. It's when I need to use Autohotkey to copy data out of a spreadsheet to be sent to another program. Still, in 2024, with the current version of Office 365 Excel, I will get the error "We could not copy the content to the Clipboard, it is in use by another application", breaking the flow of my macro.
I never have that issue when copying data out of Libre Calc, so I work with my data and formulas in Excel, then open the spreadsheet with Calc when it's time for Autohotkey to do its thing. It's a narrow use case for me but I appreciate Calc for being the workaround I need for that.
Sheets is decent too though, I've made macros for others that use Sheets and did not have any issues working with it.
Surprising to see that here. It's usually not the solution that corporations choose and for home use it's good enough. Yeah it doesn't work nearly as well as real Excel but it's manageable for simple things.