Named Functions - Reduce Formula complexity / Low hanging Fruit to enable functional Programming in Calc

Thanks. I’ll fill it out over there.

You are right. I was using the comparison just to show how much more powerful a calc sheet becomes by just adding this feature. Entire Websites are written in lisp, which just means in this context here that it will take a while to exhaust the possibilities, while currently you are forced to write somewhat ugly and complex functions which works but drives me crazy when I revisit a sheet like 6 month later and I do not understand anything anymore.

Would love to see this too. I use the hell out of Excel Lambdas at work.

Just FYI, there is an enhancement request for this in Bugzilla:

Bug 138749: Add function LAMBDA for interoperability with MS Excel

Excel introduced LAMBDA and related functions in 2020, and Google Sheets has them too. I think LO is behind on this one.