Theoretically these are all problems with Excel, not with spreadsheets in general.
Also Excel does support circular references; I once worked for a guy who used them to iteratively fit a model!
I'm waiting for "the programmer's spreadsheet" where you have functions, clean separation of "data" and "display", proper types, and some kind of sensible version control.
Also Excel does support circular references; I once worked for a guy who used them to iteratively fit a model!
I'm waiting for "the programmer's spreadsheet" where you have functions, clean separation of "data" and "display", proper types, and some kind of sensible version control.