3 ms·
I feel like spreadsheets are the wrong approach to the sort of things they're used for anyway. People always end up using a single sheet to store multiple table
by IshKebab 5y ago
I feel like spreadsheets are the wrong approach to the sort of things they're used for anyway. People always end up using a single sheet to store multiple tables, which is a recipe for disaster.
You don't need 3D sheets, what you really want is a canvas where you can add multiple tables on the same "sheet" that don't share rows or columns at all.
You can sort of achieve that in Excel by restricting each sheet to exactly one table, but it's very unergonomic (do you have an entire sheet for each scalar input?) so nobody does it.
I'm sure someone has made something like I've described.
- stevesimmons 5y agoMicrosoft very nearly made this back in 1990, with their Object Linking and Embedding (OLE) [1] technology, in Windows 3.1 and MS Office. From the name OLE, I envisaged a Word doc with multiple embedded Excel tables, with calculations in one table used to drive those in another, and Word formulae able to include any Excel table/cell value. In practice, anything complicated caused the compound document to freeze up or not update. My "half way house" to that vision of arbitrary tables would been a traditional Excel worksheet with a UI able to be "cut" horizontally so that different row ranges could choose their own column widths. A kind of step-sister to the Freeze Rows command. The A1:B2-style cell references would still cover the whole worksheet. Just now each section could pick their own column widths. [1] https://en.m.wikipedia.org/wiki/Object_Linking_and_Embedding https://en.m.wikipedia.org/wiki/Object_Linking_and_Embedding
- ximeng 5y agohttps://strlen.com/treesheets/ https://strlen.com/treesheets/
- IshKebab 5y agoBit unclear from the website if that supports formulas but yeah that's the sort of thing I was thinking!