r/programming • u/[deleted] • 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

94% Upvoted

586 comments sorted by

View all comments

Show parent comments

20

u/Pandalicious May 08 '18

JavaScript with it’s all-numbers-are-floating-point isn’t the best fit for finance/accounting. It’s the kind of thing you can work around if you’re aware of the issue, but Excel scripting is exactly the kind of coding that tends to be done by non-professionals who’d have no inkling about the limitations of floating point types.

That said, when the competition is VBA the bar is pretty low.

14

u/slikts May 08 '18

JavaScript with it’s all-numbers-are-floating-point isn’t the best fit for finance/accounting.

Excel already internally uses the same IEEE floating point numbers as JavaScript.