3 ms·
I think another change is needed for spreadsheets to be a more reliable tool. Right now a sheet is a full document thing. Meaning that it starts with A1 in top
by digi_owl 11y ago
I think another change is needed for spreadsheets to be a more reliable tool.
Right now a sheet is a full document thing. Meaning that it starts with A1 in top left, and spreads out from there.
but what if you could break a "sheet" down into units?
So that you can have say a constants unit, with its own A1 to whatever as needed, and then another unit, perhaps called results, that hold the formula in their own A1 to whatever, each unit movable and extendable on the screen at the same time.
Now if formula A1 wants to refer to something in constants A1, the entry would look something like constants(A1).
This way one would have everything on screen, while avoiding the worry that as the sheet grows and one move things around to make it more readable, the formulas are referencing the wrong cells.
- brenschluss 11y agoThat's what different worksheets are for.
- digi_owl 11y agoYes and no. Yes you can do it with worksheets, but no its not quite what i am talking about because worksheets can only be on screen one at a time.
- brenschluss 11y agoGood point, but I'd say that could be solved with UI - split-screen dual-worksheet views.
- zyxley 11y agoThis is literally exactly what Numbers.app on OS X does.