News for hackers. Stuff that matters.

A comment on The coordinate system for an infinite spreadsheet.

Re:The coordinate system for an infinite spreadsheet by HPsquared on Monday May 29, 2023 @09:23AM (#36113690)
Try out "R1C1" reference style in Excel.. it's quite enlightening to see how things actually work.

If I have a formula in cell C4 saying "=$A4 * $A$1 + B4", that would translate to a formula in cell R4C3, "=RC1 * R1C1 + RC[-1]".

The relative references are much clearer. If you "fill" a formula it looks the same everywhere.

[ Parent | on HN ]
Re:The coordinate system for an infinite spreadsheet by davidkircos on Tuesday May 30, 2023 @11:17AM (#36125873)
The plan is to switch to R1C1 under the hood.
[ Parent | on HN ]