Imagine not being able to open a spreadsheet from 5 years ago.
I’ve been hot for this feature since the Improv days — I browbeat the AppleWorks people to support it better, and when a bunch of them split off to build <app I don’t remember the name of> I made sure they knew this was a key feature.
Ragtime still supports it as far as I know. https://www.ragtime.de/start.html?lang_id=en
It was one of the reasons I ‘got in to computers’(Macs) - it felt like it could ‘do it all’ and was so easy to use (at the time x86 based pc’s did not do the same for me…
I love the idea of having multiple worksheets in a particular document so much, and yet 99.9% of the time I just throw open a google sheet and start throwing in numbers. The collaboration smoothness is a beats-all-else feature.
Don't sleep on Numbers. It doesn't get a lot of attention but it can do some nice things in a much less bloated interface than Excel.
It's had regular expressions for a while for example, while Excel is just getting them.
I love being able to put multiple spreadsheets on a page and arrange them in whatever way you want. Reminds me of Lotus Improv [1] from back in the day.
[1]: https://en.wikipedia.org/wiki/Lotus_Improv