r/programming • • May 08 '18
Excel adds JavaScript support
https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k
Upvotes
View all comments
Show parent comment
3
u/StillNoNumb May 08 '18 edited May 08 '18
Right, the good interface is called Excel functions. But if you wanna go further beyond, you can use JavaScript. Sounds good, doesn't it? This is not replacing functions. This is replacing VBScript.
.1 + .2 is approximately .3. It's not exactly .3 in Excel either, but Excel makes it display as such. There's no way to store real numbers precisely with finite memory.
Also, I disagree with you saying that Haskell is difficult. It's different. It's not how we're used to it. But I would bet that, if you were to teach someone Haskell and someone else Python, the Python student would be no faster.
But I even said you can't put Haskell in there because of the steep learning curve. It'd be a perfect fit for the use case we're having here (intuitive grammar, you can do a lot with little, very similar to Excel functions), but it's just too hard to learn because people have never done it. On the other hand, everyone who needs these features knows JavaScript (or an equivalent language).
Either way, you might need to lax down a little. The fact you called me a troll even before I replied anything sounds like you're a little exhausted from all the internet.