I think spreadsheets have been severely undervalued by software engineers and they're generally under-researched. It's definitely possible to use them in more non-obvious and interesting ways. E.g., see AmbSheets [1]

[1] https://www.inkandswitch.com/ambsheets/notebook/

You can do this in Excel but it's not all in one cell [0].

[0] https://support.microsoft.com/en-us/office/spilled-range-ope...