For my use case, mainly science stuff, works like a charm. I find Calc better because I could never get used to the ribbon, and it's also way faster. I actually did my whole thesis in LibreOffice, including all text, references and figures. Afterwards, during the PhD, it was replaced mostly by Python and R, but at that point I was really hitting some resource limits with huge CSVs.

No. Excel really doesn't have an equivalent replacement. Other parts of the office suite do although if you're a lawyer (revision marking) or have other specific integration needs, you probably need Word.

If you're just doing lists with maybe some simple calcs (which is what most people use spreadsheets for most of the time), pretty much anything works.

I sometimes use it for personal use and it seems all right, but I'm not a power user.

I've been finding myself using Google Sheets more, which has the potential for the same problems in this article.

The main issue is that excel has some proprietary features that make it hard to migrate off.

Otherwise calc has everything for most people. Macros work different a little.

It might be a worthy replacement for Excel 95, but not really for anything modern.

It works with csv which is totally broken in excel