MicrosoftThis is fantastic news!
Chris_Gross Brian Jones (OFFICE) Thank you, guys! I've a couple of questions if you don't mind
1. I didn't had a chance to test it yet but are lambdas first-class citizens, e.g can i pass a function as a function argument? 🙂
1. Why LAMBDA formula has been introduced instead of using ()? I'm sure you've think of it but wondering what was the obstacles prevented it.
2. Excel formula languages is increasingly moving towards a fully fledged functional programming language with LET() and LAMBDA(). But tools which are available to "real" developers (IDE, code analysis tools, etc) are simply non-existing in the Excel world.
For instance LET() function was shipped without ability to debug names with F9 key...
Do you have plans in foreseeable future to bring those features? Formula formatting, debugging (at least with F9), code navigation (jump to function definition, etc) and so on.
Thank you!
