Hi,
Here's what I'm trying to do (without success) in my spreadsheet:
I have a first table :
#+TBLNAME: table1
| ... |... |.... |...|...
and a second table:
#+TBLNAME: table2
| line_reference | ... |... |.... |...|...
The line_reference is the line number to get some information in the
table1. So in a cell of the table2, I tried a formula like:
remote(table1,@$1$3) ($1 = the line_reference) which of course, didn't work.
then I tried to use elisp: remote(table1,'(concat "@" $1 "$3")') ....
but no success anyway.
after all, I decided to merge my 2 tables because it looks like I can
use elisp inside a org function (remote). The last tried formula was:
'(concat "@" $1 "$3")' ,($1 = the line_reference). The problem of this
formula is only that I got the string "@2$3" inside the cell and it's
not evaluated as a formula.
Could anyone give me some hint to get done what I'm trying to do?
regards,
Alan
--
Alan Boudreault
Mapgears
http://www.mapgears.com/
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
