Ask Your Question

Change column letters to numbers? [closed]

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

appreciatethehelp gravatar image

updated 2020-07-22 07:51:56 +0200

Alex Kemp gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-22 07:52:35.294018

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

Question Tools

1 follower


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

Seen: 9,761 times

Last updated: Apr 21 '17