5 ms·
>Zero-based numbering creates an asymmetry across the grid origin making it difficult to notice the subtle “off-by-one” mismatch between two seemingly symmetric
by mikewarot 3y ago
>Zero-based numbering creates an asymmetry across the grid origin making it difficult to notice the subtle “off-by-one” mismatch between two seemingly symmetrical cell references.
No, it doesn't... the fault is assuming that the cells have a "width", or alternatively, that the cells coordinates aren't in the center of the cell.
If you treat the cells as if they are centered on coordinates, the problem is resolved. (-2,0) is 2 to the left, and (2,0) is 2 to the right of the origin.
[Edit] I'm not talking about the display format, I'm talking about the representation/metaphor... it doesn't matter how things look on the screen... -2 is 2 cells left, +2 is 2 cells right of 0.
- jasode 3y ago>If you treat the cells as if they are centered on coordinates, the problem is resolved. (-2,0) is 2 to the left, and (2,0) is 2 to the right of the origin. The article's screenshot already shows the cells "centered on the coordinates": https://www.quadratichq.com/assets/blog/2023-05-15-coordinate-system-for-infinite-spreadsheet/4.png https://www.quadratichq.com/assets/blog/2023-05-15-coordinat... The issue is the row-0-column-0-cells are themselves also "containers" and making those cells "inclusive" of either the positive or negative range of cells will make it asymmetric.
- MereInterest 3y agoThe problem with the screenshot is that it measures to a different location of each cell. They measure to the top-left of (2,2), but the bottom-right of (-2,-2).