@enkiv2 OK, I'm gonna go the other direction with this hot take, than I usually do, given the context.
I'm going to argue that Excel is a radically different form of IDE, not a mere document editor, and therefore a degree of Turing-completeness is expected.
It's still not a great situation, though...
You make a good point: formulas are a fundamental selling point of spreadsheet programs.
I still think they probably shouldn't be turing complete.
Granted, Excel isn't on every machine, but it's something that lets users, not just programmers, develop task-specific software relatively easily.
I've seen this take before. I'm not 100% sure I buy it. Spreadsheet formulae are both more technical and more limited than BASIC. Something like Twine is a better match (though again most people don't have a copy).
Non-technical users can and do create incredible things in spreadsheets, but I think you'll probably find that nearly all of them went to company-sponsored seminars on spreadsheet formulae to gain those skills.
I've used it in the past in a previous job to parse raw text files containing financial data from Oracle systems into spreadsheets than could be further analysed.
Word and other MS office apps have the same functionality (which can and indeed has been misused by malware already, hence the security settings needed to turn on macros on documents)
@bhtooefr @calvin @enkiv2 I've seen mixtures of these *and* "proper" VBA functions in some code (especially when put together by accountants rather than those who have even basic knowledge of coding).
To be fair, it often works a fair bit of the time until its fed with data containing some odd edge case like a control character in a text file and the whole thing chokes.
I remember explaining to colleagues the innocent lookng "square box" in that text file is *not* always the same thing 😉
The social network of the future: No ads, no corporate surveillance, ethical design, and decentralization! Own your data with Mastodon!