Microsoft
"there is nothing to say that you shouldn't use the grid for development and testing. "
Yes, it would be a good practice to dedicate sheets to test your lambda functions.
But I thinks it is a pity : worksheets should stay "Business Oriented", do you agree ? A sheet is a free space where a lot things can happen, and programming construction requires some stability. Users don't want to be trouble with technical stuffs during their business tasks.
If you want to do programming, use the adequates tools : VBA or JS or .NET. It's away from common users : this distance provides security for both part.
Giving the "modularity" and "recursivity" to Excel Formula will not make the cat's vomit better, it will make it more acid than ever.
Maybe I am pessimistist, the future will tell.
"One of the plusses of Names is that they can capture the intent of the operation in business terms"
Again I am sorry but in practice, Georges will use the lambda function "GetLocation()" to extract "Amanda" from "123-Amanda-01" because...it works technically, regardless of whether "Amanda" is not a Location. Georges is not a programmer, he does what it works fast ; he may not know how to build those lambda functions so he will use existing ones. Do you imagine what kind of problem we are facing here ? Sharing a bad name for technical purpose.... The choice between building a new lambda or modify one and trying to guess the impact.... These are common programming problems, but just in face of a end user, and without the adequate tools to solve it. Brrr.
I hope you are right and I am too pessimistic 🙂 Have a nice day.
