Where R1C1 addresses was used?

[st]

Was there some other spreadsheet which used such addressing? Why such bizarre convention was defined?

 

[Gordon]

Was there some other spreadsheet which used such addressing? Why such
bizarre convention was defined?

AFAIK ALL spreadsheets use that convention. What else would they use?

 

[Niek Otten]

Multiplan (Excel's predecessor) used only R1C1 style references.
It's not bizarre at all; it's just that you're probably used to A1 style.
Refencing the row above, for example, is easy and understandable; R[-1] and
the same in any row.

I still use it a lot, but never for work I have to share with others,
because it seems to confuse some...........

 

[Bob Phillips]

I still use it a lot, but never for work I have to share with others,
because it seems to confuse some...........

What do you expect from a bizarre convention? <bg>

 

[Dave Peterson]

R1C1 reference style can be very useful.

You can write a formula to sum from row 2 to the row above with an R1C1 formula
like:

=sum(r2c:r[-1]c)

It would be a pain to toggle the setting, write the formula, then toggle the
setting, though. But if you're writing a macro that does the same thing, the
code is easier:

dim myCell as range
set mycell = somevariablerangehere
mycell.formular1c1 = "=sum(r2c:r[-1]c)"


And if you're looking for inconsistent formulas, you can toggle this setting
(and widen the columns), show formulas, and almost use the naked eye to find any
formulas that don't belong.

(or use code to look at .formular1c1 to see if it matches the one above.)