Ask Your Question

cell indentification [closed]

asked 2018-03-17 15:14:27 +0200

ROSt52 gravatar image

Normally I work with characters for columns and number for rows.

For a special application I need the columns also with numbers.

I don't find any settings, which changes from COLUMN CHARACTER to COLUMN NUMBERS.

How can this be set up in Calc?

Thanks in advance for helpful replies!

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 2021-04-29 00:53:05.298084

2 Answers

Sort by » oldest newest most voted

answered 2018-03-17 15:23:11 +0200

librebel gravatar image

Hello @ROSt52,

You could use the Excel R1C1 notation for that, see menu Tools : Options : LibreOffice Calc : Formula : Formula Options : Formula Syntax : Excel R1C1.

Please also see this recent thread about R1C1 notation

HTH, lib

edit flag offensive delete link more

answered 2018-03-17 16:12:57 +0200

Jim K gravatar image

updated 2018-03-17 16:31:25 +0200

To do this with specific cells and not the entire spreadsheet:

Use only numbers to reference a cell.


Reference a cell in R1C1 format.


Get the current cell address in R1C1 format.


Use for example ROW()+1 to get a relative address offset, then wrap with INDIRECT to reference the cell.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-03-17 15:14:27 +0200

Seen: 601 times

Last updated: Mar 17 '18