MicrosoftSorry, I think this new lambda function could a bad idea 😞
It allows to do complex things without the possibility of :
- putting break point, debug-mode, step-by-step
- having autocomplete when your write it, automatic syntax check, syntax color.
- possibility of organizing your functions
- commenting your code
- organized units tests
Actually, it seems to allows the richchness of code, without the possibility of doing a clean code. Without lambda, it's already the biggest drawback of Excel : when your sheet become a nightmare to understand for someone who doesn't create it.
I think Formulas should be kept simple. Maybe we need a better native solution to transform "10003487-WA-73" into "WA".
Suggestion : "=INDEXSPLIT("10003487-WA-73", "-", 2). And so on, for each problem of that kind.
If you want to do complex thing, simply make multiples columns, split your calculus. That way, it's will be easier to detect error as it show up into the corresponding column. This is crucial for users ; developpers enjoy debugging, users really don't.
I already see a lot of developper being entousiastics : "Oh yes, recursion, lambda, such a power !".
I hope they will enjoy the power of debugging the 30 ugly lambdas functions, written by Georges the accountant, without any serious developping tools.
Nevertheless, it's nice to see some moves on Excel 🙂
Best Regards.
