3 ms·
Yes, clicking on "this thing right here!" is a powerful way for ordinary users to create references. It shouldn't be underestimated. Programmers are so used to
by pavlov 9y ago
Yes, clicking on "this thing right here!" is a powerful way for ordinary users to create references. It shouldn't be underestimated.
Programmers are so used to having to name things that we don't see the mental overhead of using names. A named cell is conceptually a pointer -- you can change what it points to (by giving the same name to some other cell instead), and if you delete the referent, it can point to nothing. That kind of invisible indirection is not easy for non-programmers.
- DonHopkins 9y agoAn important thing about cell references that makes them almost but not quite entirely unlike pointers is that they can be relative, absolute, or mixed. https://support.office.com/en-us/article/Switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9 https://support.office.com/en-us/article/Switch-between-rela...
- pavlov 9y agoAren’t named cells/columns a category of their own? They’re not relative nor absolute, but resolved by the name binding that exists at evaluation time.