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

"st" wrote in message
...
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?

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...........


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"st" wrote in message
...
Was there some other spreadsheet which used such addressing? Why such
bizarre convention was defined?

"Niek Otten" wrote in message
...

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

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.)



st wrote:

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

--

Dave Peterson