Beni Cherniavsky-Paskin
07/07/2023, 2:55 PMGOSUB 437
means; easier if you assign semi-systematic round GOSUB 2100
.)
So, suppose spreadsheets let you use higher numbers/column names freely, by skipping display of unoccupied rows/columns.
⢠If you have a long table that might grow, you won't put =SUM(...)
computation directly beneath it; you put it at next 100 or 1000 ā but it will still display close to its bottom. And you can type the range as 10:99
from the start.
⢠With some foresight allocating "big enough" ranges for tables, you might never run into situations where $B7
vs. B$7
matters. (This means spreadsheet should become smarter yet in renumbering on insert/delete ā do shift rows/columns, but stop at next unoccopied "moat".)
⢠To introduce users to the idea, don't show consecutive numbers/letters. Even in an empty spreadsheet, after some rows/columns, skip to some far-away numbers like 100 and 1000!
⢠Perhaps it might also subsume the feature of "freezing" some rows/column from scrolling? mockup below has one fake "scrollbar" to suggest a portion could be scrolled separately.
attaching a mockup to this thread (drawn in a regular spreadsheetš)Gregg Irwin
07/07/2023, 5:12 PMtable
type to our language, like you can have a table in a spreadsheet (at least in Excel), which gives you this sub-thing that is a logical unit and structure, which can grow or change shape.
On the viz side, the trick is how to improve this. Today, at least in Excel, you have the worksheet model, and that's all you get for UI (bear with me). e.g. you can't make a table and pop it up in it's own window. Worksheets are a flat stack, rather than something like MDI child windows. But what if you could do that, maybe something like Oberon or totally free-form. If you want to merge them all into a flat worksheet, their range IDs provide the layout positions, but they also have names and can be addressed relatively that way as well.Naveen Michaud-Agrawal
07/07/2023, 5:35 PMwtaysom
07/07/2023, 11:30 PMBeni Cherniavsky-Paskin
07/08/2023, 9:07 PMB$4
notation due to relocation, but it'll still be needed for replicated formulas when mixing cscalars/vectors/matrixes :-(
E.g. if you have a column of prices * scalar tax rate stored in single cell, the reference to that cell must be absolute.