(1) Optional Fortress like "typing". It's almost always a mistake to add a number representing an amount of dollars to a number referring to feet. And feet can't be added to meters. Heck, it's typically wrong to add gigabytes to megabytes without a conversion (which depends on whether you're talking about disk space or ram).
(2) Many of the complaints mentioned come from the way that a given entity, "the sheet" (or page) is used to both computation and to present multiple computations. Rethinking that is likely to yield huge benefits.
(3) It should be possible to tag computations so they can be more easily used to build other computations. For example, I was recently doing some cost analysis and realized part way through that I'd like to break down the numbers in other ways. Since I was using a sequence of equations in an ordinary programming language, it was easy enough to define appropriate accumulators and pick up the values from the equations, but it would have been a pain with a spreadsheet. And, my solution was too granular.
I'm not expressing (3) very well, but I think that it's a big deal, so feel free to contact me.
(2) Many of the complaints mentioned come from the way that a given entity, "the sheet" (or page) is used to both computation and to present multiple computations. Rethinking that is likely to yield huge benefits.
(3) It should be possible to tag computations so they can be more easily used to build other computations. For example, I was recently doing some cost analysis and realized part way through that I'd like to break down the numbers in other ways. Since I was using a sequence of equations in an ordinary programming language, it was easy enough to define appropriate accumulators and pick up the values from the equations, but it would have been a pain with a spreadsheet. And, my solution was too granular.
I'm not expressing (3) very well, but I think that it's a big deal, so feel free to contact me.