Where R1C1 addresses was used?

  • Thread starter Thread starter st
  • Start date Start date
S

st

Was there some other spreadsheet which used such addressing? Why such bizarre convention was defined?
 
st said:
Was there some other spreadsheet which used such addressing? Why such
bizarre convention was defined?
Click to expand...


AFAIK ALL spreadsheets use that convention. What else would they use?
 
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...........
 
I still use it a lot, but never for work I have to share with others,
because it seems to confuse some...........
Click to expand...

What do you expect from a bizarre convention? <bg>
 
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.)
 
Back
Top