Earlier quoted context omitted.
I can barely tell the difference between Excel and LibreOffice Calc with both of them open on the same computer...
"Then you haven’t really used excel beyond loading a CSV into a table." Bad example. I've brought LibreOffice to its knees after importing a CSV file: went to adjust a column width and it became non-responsive. And this was within the last year. They have done a lot of performance work on LibreOffice and I appreciate that, but it is a long way away from Excel for serious work. My favorite snag was on a plot with the…
I've crashed Excel (2016 for Mac) trying to preview CSV I was about to import.
To Microsoft's credit, they eventually fixed it.
What still doesn't work (in Mac version) is ODBC driver for Postgresql (and maybe for other databases; it is shipped with MSSQL driver only). It will also crash Excel. So to work with psql data I have to export them into file and then import into Excel. I cannot have a query saved in the spreadsheet and just refresh it.