Ask Your Question

DaveA's profile - activity

2016-02-19 11:48:05 +0100 received badge  Famous Question (source)
2015-01-02 16:35:48 +0100 received badge  Famous Question (source)
2015-01-02 16:35:48 +0100 received badge  Notable Question (source)
2014-03-07 22:13:26 +0100 received badge  Notable Question (source)
2014-02-25 02:49:00 +0100 received badge  Popular Question (source)
2014-02-24 15:33:41 +0100 asked a question Is there a LibreOffice equivalent of Lotus123 @CELLPOINTER

@CELLPOINTER(attribute) returns an attribute of current cell

2014-02-24 13:49:53 +0100 commented question can i emulate lotus 123 function (@COORD()) inlibre calc

thanks for prompt help

2014-02-24 13:47:35 +0100 received badge  Scholar (source)
2014-02-23 10:58:35 +0100 received badge  Popular Question (source)
2014-02-22 14:31:23 +0100 asked a question can i emulate lotus 123 function (@COORD()) inlibre calc

@COORD(worksheet,col,row,cell_absolute) constructs a cell address corresponding to worksheet, row,col, cell_absolute: 1=$A:$A$1…….8=A:A1 e.g @COORD(1,5,3,1) Sheet 1, col 5, row 3, absolute @@(@COORD(C1;D1;E4;8)) returns the value in cell A:A4 (C1 contains 1; D1 contains 1; and E4 contains 4).