3 ms·
It would be hard, but I think a new kind of spreadsheet that was easier to validate, easily impose a schema and constraints and helps us identify human errors w
by jay_kyburz 5y ago
It would be hard, but I think a new kind of spreadsheet that was easier to validate, easily impose a schema and constraints and helps us identify human errors would be helpful.
I bet excel has some excellent features around this, but they are not front and center in the UI.
- arthurcolle 5y ago> easier to validate, easily impose a schema and constraints and helps us identify human errors would be helpful. yeah, it's called IF
- throwawayboise 5y agoLotus Improv was a bit like that I think. It's been a long time since I used it. Wikipedia says: Conventional spreadsheets used on-screen cells to store all data, formulas, and notes. Improv separated these concepts and used the cells only for input and output data. Formulas, macros and other objects existed outside the cells, to simplify editing and reduce errors. Improv used named ranges for all formulas, as opposed to cell addresses. https://en.wikipedia.org/wiki/Lotus_Improv https://en.wikipedia.org/wiki/Lotus_Improv Like most of the software on the NeXT platform, it was ahead of its time.