R1C1 reference style

Discuss the spreadsheet application

R1C1 reference style

Postby d_q_d » Wed Dec 19, 2007 3:03 pm


Apologies if this has already been discussed, I did a few searches but couldn't uncover anything.

In Excel I use the r1c1 reference style because it allows greater adaptability in relative referencing than A1, B1 etc. e.g. R[-5]C1 references column one in the cell 5 rows back from the current cell. It looks like Calc doesn't have this feature. Is this the case, or is there an alternative way of doing this?

Thanks very much,

Posts: 1
Joined: Wed Dec 19, 2007 2:14 pm

Re: R1C1 reference style

Postby huw » Wed Dec 19, 2007 4:12 pm

You could register, and vote for issue 20857.
Posts: 417
Joined: Wed Nov 21, 2007 1:57 pm

Return to Calc

Who is online

Users browsing this forum: No registered users and 15 guests