From mboxrd@z Thu Jan 1 00:00:00 1970 From: Alan Boudreault Subject: org-table and formulas Date: Mon, 11 Jan 2010 14:32:37 -0500 Message-ID: <4B4B7CD5.80907@mapgears.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NUQ0C-0006oJ-Fj for emacs-orgmode@gnu.org; Mon, 11 Jan 2010 14:32:36 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1NUQ07-0006lO-TH for emacs-orgmode@gnu.org; Mon, 11 Jan 2010 14:32:35 -0500 Received: from [199.232.76.173] (port=55023 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NUQ07-0006lI-NE for emacs-orgmode@gnu.org; Mon, 11 Jan 2010 14:32:31 -0500 Received: from smtp151.iad.emailsrvr.com ([207.97.245.151]:33683) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1NUQ07-0006Vh-Aa for emacs-orgmode@gnu.org; Mon, 11 Jan 2010 14:32:31 -0500 Received: from relay25.relay.iad.mlsrvr.com (localhost [127.0.0.1]) by relay25.relay.iad.mlsrvr.com (SMTP Server) with ESMTP id B93331B402F for ; Mon, 11 Jan 2010 14:32:26 -0500 (EST) Received: by relay25.relay.iad.mlsrvr.com (Authenticated sender: aboudreault-AT-mapgears.com) with ESMTPSA id 9E4AA1B406C for ; Mon, 11 Jan 2010 14:32:26 -0500 (EST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org 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/