|
|
|
|
|
|
by slaymaker1907
1884 days ago
|
|
|
You definitely don't want to write anything complicated with it, but I think it is a nice intermediate that is more secure than macros and also is closer to writing Excel formulas than implementing custom macros. One thing that would greatly improve the experience would be to allow for formulas to contain just a lambda and then reference that lambda from another cell as a cell reference. Currently you have to use manage lambdas under Formulas > Name Manager. This would make debugging a lot easier in my opinion so that you can freely mix data entry with computation. Not sure why they haven't done this already, but I suspect it is because of assumptions baked into Excel. |
|
|
My pet project from a couple of years ago[1] had cells-as-functions. I think it works really well. I also think names are important, but yeah they should either be easy or optional. Glad the Excel folks liked my rad idea though, even if they didn't quite hit all the high notes :-).
1: https://6gu.nz/, IMO worth watching the first minute of the video to see it in action