[javenho14]

I agree with that. Spreadsheets are Turing complete but realistically you aren't really 'programming' to the extent that program languages allow you to unless you're doing so in a locked down environment like you've said. However, it's pretty clear that the "up front costs" of creating basic data analysis and formulas is much feasible in Excel than Python (no need to learn syntax, CLI, etc.) If only spreadsheets could innovate the UI of more advanced features ... maybe it could be the greatest low-code tool of all time, if not already.

[mcdonje]

Spreadsheets are definitely already the greatest low-code tool of all time. Not sure what innovations you're looking for. There have been all sorts of advanced features added to excel over the years, some requiring more code to work with than others. Like power query and power pivot.

I think what makes spreadsheets as popular as they are is the flexibility. Most low-code solutions sacrifice too much power, which causes users to get frustrated whenever something outside of the normal workflow happens.

[Gibbon1]

I can't help but remember this back and forth between a functional programming geek and a older cynical programmer.

FP: It's terrible functional programming isn't used more.

Cynic: What do you mean? More people use functional programming than anything else.

FP: Wait what?

Cynic: People write more excel spreadsheets than anything else.