News for hackers. Stuff that matters.
Re:Lambda: Turn Excel formulas into custom functions by Closi on Sunday December 06, 2020 @04:31PM (#25326854)
The differences seem to be:

* You can write it in one language (excel formula language)

* The language is simpler and known by almost all users, while Javascript and VBA are only used by a tiny proportion of users.

* The language is more secure (i.e. you can't execute arbitrary code, access files, call DLLs etc)

* Because of the above, users don't need any security permissions / get warnings when running it.

* Because they are standard excel formulas, you get OOTB support for other excel features such as dynamic array formulas and access to the full catalogue of worksheet functions (even in VBA, Application.Worksheet only had access to a few basic excel workbook functions, so if you wanted to do a Xlookup for example you are implementing it yourself with arrays and loops)

Re:Lambda: Turn Excel formulas into custom functions by fomine3 on Monday December 07, 2020 @12:29AM (#25329572)
Yes it's good but "revolutionize" is misleading.
Re:Lambda: Turn Excel formulas into custom functions by Closi on Monday December 07, 2020 @02:13AM (#25330028)
I don’t think it’s misleading, I mean everyone’s definition of “revolutionary” is different, but let’s put it into perspective: this is adding functions and recursion to one of the worlds most popular data analysis languages.

I think most people on this site know how powerful the concepts of functions and recursion can be!

Re:Lambda: Turn Excel formulas into custom functions by fomine3 on Monday December 07, 2020 @04:37AM (#25330651)
Functions and recursion is already there, but only with VBA. I'll say revolutionize if VBA wasn't exist.