Ask Your Question
1

cell indentification

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 close merge delete

2 Answers

Sort by » oldest newest most voted
1

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
0

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.

=INDIRECT(ADDRESS(3;1))

Reference a cell in R1C1 format.

=INDIRECT("R3C1";0)

Get the current cell address in R1C1 format.

=ADDRESS(ROW();COLUMN();;0)

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 254 times

Last updated: Mar 17 '18