[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] org-table and formulas
From: |
Alan Boudreault |
Subject: |
[Orgmode] org-table and formulas |
Date: |
Mon, 11 Jan 2010 14:32:37 -0500 |
User-agent: |
Thunderbird 2.0.0.23 (X11/20090817) |
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/
- [Orgmode] org-table and formulas,
Alan Boudreault <=