Change column letters to numbers?
As per title; I want numbers instead of letters, just like the rows, if possible.
First time here? Check out the FAQ!
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
RC[-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.
Asked: 2017-04-20 23:50:26 +0200
Seen: 25 times
Last updated: 2 days ago