From: Alan Boudreault <aboudreault@mapgears.com>
To: emacs-orgmode@gnu.org
Subject: org-table and formulas
Date: Mon, 11 Jan 2010 14:32:37 -0500 [thread overview]
Message-ID: <4B4B7CD5.80907@mapgears.com> (raw)
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/
next reply other threads:[~2010-01-11 19:32 UTC|newest]
Thread overview: 6+ messages / expand[flat|nested] mbox.gz Atom feed top
2010-01-11 19:32 Alan Boudreault [this message]
2010-01-13 10:23 ` org-table and formulas Sébastien Vauban
2010-01-13 11:14 ` Alan Boudreault
2010-01-13 11:56 ` Stephan Schmitt
2010-01-13 11:59 ` Carsten Dominik
2010-01-13 12:23 ` Alan Boudreault
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=4B4B7CD5.80907@mapgears.com \
--to=aboudreault@mapgears.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).