Ask Your Question

How to refer to the current cell in librecalc [closed]

asked 2013-09-17 20:44:44 +0200

Amir H. gravatar image

I just couldn't find anything regarding the referring to the current cell in librecalc. e.g in excel it is like () .

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-09 04:20:32.793186

2 Answers

Sort by » oldest newest most voted

answered 2013-09-18 18:43:20 +0200

w_whalley gravatar image

ADDRESS(ROW(),COLUMN(),1) returns the current cell as an entry like $A$1. Change the third parameter to 2, 3 or 4 to get respectively A$1, $A1, A1.

edit flag offensive delete link more

answered 2013-09-18 22:08:29 +0200

m.a.riosv gravatar image

As you do not explain what do you mean for referring to the current cell. Maybe @w_waalley answer is what you are looking for.

Also you can use CELL() without the reference parameter, in this case their result is taken from the actual cell.

Returns information on address, formatting or contents of a cell.
CELL("InfoType"; Reference)
InfoType is the character string that specifies the type of information. The character string is always in English. Upper or lower case is optional.

You can look for InfoType in the LibreOffice inner help for the function.

edit flag offensive delete link more

Question Tools



Asked: 2013-09-17 20:44:44 +0200

Seen: 9,319 times

Last updated: Sep 18 '13