[Orgmode] org-table and formulas

[Alan Boudreault]

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/