Grist is a spreadsheet with Python support (I am a founder). Python does make some formulas far easier. Nice to see Excel has data science libraries included from the start, that's something we've had our eyes on for a while. On the other hand, Grist is open source and can be run locally.
For example:
As part of a monitoring system.
HR / crm Database.
Self serving vacation planner and approving system.
Tamperproof GMO(genetically modified organisms) database.
As my go to source as a quick and dirty data dump while hacking...
It's a spreadsheet, Excel was always our primary competition! :) The more Excel follows us, the better for everyone. Python is a start, but they have a way to go. Imagine proper relational data, self-hosting for cloud Excel, open-source, access rules....