4 ms·
I should probably have phrased what I said a bit differently. I have not had trouble understanding relative offset and how to use it. What I've always wondered
by eriknstr 10y ago
I should probably have phrased what I said a bit differently. I have not had trouble understanding relative offset and how to use it. What I've always wondered about and finally got an answer to in this video is how the implementation works so that Excel is able to preserve the offsets even when pasting a cell in a random location into a spreadsheet :)
- greggyb 10y agoAh gotcha. Yeah, for that I just had an implicit mental model of R1C1 without realizing it was physically implemented. I interpreted you (wrongly it seems) as saying that the relative offsets were confusing and I responded to that. You were curious about the implementation instead. I didn't care about the implementation when I was learning Excel, and simply assumed a mechanism like R1C1 without much interest in it.