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

585 comments sorted by

View all comments

4

u/[deleted] May 08 '18

While I like JavaScript I think the fact that it's so prone to floating point errors would be a pretty good reason to not use it for software that's mainly used for working with money.

-1

u/THEtheChad May 08 '18

I think you're confusing Javascript the language/syntax with the actual implementation. Floating point errors are present in the browser because of the way the various engines implement number handling and calculations. Just because they're using "Javascript" does not mean it's functionally equivalent under the hood. Also, there are active proposals to natively support new Number types (big integers, etc).

2

u/[deleted] May 08 '18

That's true. I've never heard of a runtime for JavaScript that doesn't use only floats though. It's not just the browser, floating point errors happen in all languages where floats are used.

→ More replies (1)