R1C1 reference style

[d_q_d]

Hello,

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,

Dave

[huw]

You could register, and vote for issue 20857.