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

Show parent comments

-1

u/Agent281 May 08 '18 edited May 08 '18

Designed for stuff like this? They have one type of number and it's a double. Now accountants are going to need to know about floating point artithmetic.

I like JavaScript, but in the hands of non-programmers this is going to be a shit show.

EDIT /u/StillNoNumb, are you trolling?

0

u/[deleted] May 08 '18

[deleted]

2

u/Agent281 May 08 '18

Isn't the whole reason to embed a macro language so that you can create custom functions with it? If you literally don't have to do math with Javascript, it might be okay, but I still think multiple types of equalities (= vs == vs === ) are going to confuse accountants.

EDIT And I realize that a single = sign doesn't mean equality. I think it would be confusing for non-programmers.

2

u/StillNoNumb May 08 '18

Man, don't act like an elitist. An accountant isn't confused by the differences between = and ==, and === will literally never be useful (in Excel, "0" and 0 are the same anyways). There's nothing to learn about floating point arithmetic either (it's basic maths after all). Accountants aren't mentally retarded, and programming is nothing hard to learn either.

That said, an accountant will probably never have to deal with JavaScript in Excel. Most stuff can be done with the usual Excel formulas we know and love. But if you wanna go beyond that, now you can choose to extend upon that with JavaScript. It's win-win basically.

→ More replies (2)