Ask Your Question

Change column letters to numbers?

asked 2017-04-20 23:50:26 +0200

appreciatethehelp gravatar image

As per title; I want numbers instead of letters, just like the rows, if possible.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-04-21 00:32:46 +0200

Lupp gravatar image

updated 2017-04-21 00:39:00 +0200

You need to change the addressing mode to the "Excel R1C1" address syntax under
'Tools'>'Options'>'LibreOffice Calc'>'Formula'>'Formula Options'
Having done so you need to give references in this syntax which is logically very satisfying but may be slightly unhandy for relative addressing like in
R[1]C[-2] meaning "one row below and two columns to the left" due to the many square brackets needed.
Of course any formula containig references will show them in this syntax then.

In the "R1C1" addressing mode addresses are always absolute regarding the sheet. No relative sheet addressing possible.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-04-20 23:50:26 +0200

Seen: 5,657 times

Last updated: Apr 21 '17