Ask Your Question
0

can i emulate lotus 123 function (@COORD()) inlibre calc [closed]

asked 2014-02-22 14:31:23 +0200

DaveA gravatar image

@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).

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 2016-02-19 11:26:31.890741

Comments

thanks for prompt help

DaveA gravatar imageDaveA ( 2014-02-24 13:49:53 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2014-02-22 16:27:17 +0200

m.a.riosv gravatar image

I think they are:
COORD() ==> ADDRESS(Row; Column; Abs; A1; "Sheet")
@@ ==> INDIRECT(Ref; A1)
with the function wizard you can see the parameters.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-02-22 14:31:23 +0200

Seen: 171 times

Last updated: Feb 22 '14