3 ms·
I seem to remember that VisiCalc didn't follow the dependency graph among cells; it evaluated across the rows and columns something like left to right, top to d
by kazinator 5y ago
I seem to remember that VisiCalc didn't follow the dependency graph among cells; it evaluated across the rows and columns something like left to right, top to down.
That could work reasonably well, even in a new spreadsheet today. At worst you may need to iterate where the graph would settle everything in one round and you don't have to think about circularity since you're already having to iterate on acyclic situations.
Spreadsheets are often structured to mimic the flow of calculations in paper documents: top down, left to right data flows. A spreadsheet whose cells never reference anything to the right or below would calculate in one round.
- blihp 5y agoYep... there wasn't enough code or RAM to do anything fancy. If you had a spreadsheet of any real complexity (i.e. much more than a screen worth) it was not unusual to disable auto recalc as things got painful fast on a 1MHz 8-bit CPU. None of this was really an issue for early adopters whose primary alternative was typically paper, pencil, a [pocket|desk] calculator and a whole lot of writing.
- ngcc_hk 5y ago100% remember that one. Still got a habit of checking refresh or not … silly these days but so natural then. Wordstar, visicalc and dBase II (need z80 and 80 column card to really use them). The office suite begins here. Still remember to work with one senior user to debug her spreadsheet program (may be 123). No fun at all. In fact we said end user programming is not part of the scope of work. But the word “senior” meant something I supposed :-) :-(.
- bombcar 5y agoSome of the early spreadsheets had an option to NOT to "realtime" recalculation - you'd make your changes and then call a calculate. This comes in useful with large spreadsheets and multiple cell dependencies. IIRC the move to the "current" live evaluation allowing back-references was a major selling point for Excel.
- dragonwriter 5y ago> Some of the early spreadsheets had an option to NOT to "realtime" recalculation - you'd make your changes and then call a calculate. Some of the early spreadsheets...including every version of Excel.