Comment by arbirk
16 hours ago
Excel excels because if fills the 2D user interface. But not separating calculations from the tabular position in the UI is a historical failure and things like this is a band aid on that
16 hours ago
Excel excels because if fills the 2D user interface. But not separating calculations from the tabular position in the UI is a historical failure and things like this is a band aid on that
Having used Framework very extensively at one time, I would say that is one of the best thing about Excel.
OTOH, LAMBDA and LET enable moving the core of some calculations into user defined functions in the Name catalog. And Tables fix a lot of the cell reference issues though they need a lot of improvement to handle array spills.
This Framework? https://en.wikipedia.org/wiki/Framework_(office_suite)
I sometimes wonder about an excel-like interface where the tables and columns can be given names, reducing errors from incomplete ranges. It would be like reinventing a database though.