It is woefully behind if you have real number crunching to do.

If you need to be doing 'real number crunching', you probably shouldn't be using any spreadsheet. Excel is not MySQL or Jupyter.

I think the Google Sheets devs would agree with you that spreadsheets shouldn't be used for anything serious. That's why it's missing such basic features as an X/Y scatter plot with a line - which is trivial in any other spreadsheet program.

Personally when I have a few dozen data points and I want an X/Y plot with a line, I find a spreadsheet is a better tool than MySQL.

Gnuplot.

Yup, I pretty much guarantee that Google Sheets is not intended for people who need X/Y scatter plots. I would theorise that 99% of Excel users don't require that feature either.

MySQL and Jupyter don't have data visualization. Or are you saying the options are a) use google sheets, or b) learn to program

Jupyter absolutely includes data visualization, or rather all the major languages it supports do. But honestly, yes. Complicated work in excel is programming, it's just completely undebuggable since the logic is spread out invisibly in multiple grid dimensions, sheets, and macros.

Give me a Jupyter notebook written in a language I don't yet know any day before you give me a complicated excel monstrosity.

Not a Python guy at all, but a couple of my coworkers use Jupyter notebooks a lot, and it's definitely very cool.

Sometimes it’s not up to the user if the company they work/contract for requires it.

I need to send out Excel files to clients and they need to display 100% perfect when the client opens them with their Microsoft Excel. So using Google Sheets or LibreOffice is a risk, because while they work 99% of the time, they tend to break with power-user Excel features like integrated resource links.