I just couldn’t find anything regarding the referring to the current cell in librecalc. e.g in excel it is like ()
.
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
.
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.
CELL
Returns information on address, formatting or contents of a cell.
Syntax
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.