From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?S=C3=A9bastien_Vauban?= Subject: Re: org-table and formulas Date: Wed, 13 Jan 2010 11:23:34 +0100 Message-ID: <87y6k2gv6h.fsf@mundaneum.com> References: <4B4B7CD5.80907@mapgears.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: 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-mXXj517/zsQ@public.gmane.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hi Alan, Alan Boudreault wrote: > > 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 tabl= e1. > So in a cell of the table2, I tried a formula like: remote(table1,@$1$3) = ($1 > =3D 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 =3D 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? What I do, which works: - give a name to the cell in table1 - reference it (in table2) by its name #+TBLNAME: Eau | | Date | Relev=C3=A9 m3 | Consommation | Prix TVAC | |---+------------------+-----------+--------------+-----------| | | [2009-11-15 Sun] | 2072.6263 | 0.0000 | 0.00 | | | [2009-11-22 Sun] | 2074.1774 | 1.5511 | 1.55 | | | [2009-11-29 Sun] | 2076.0834 | 1.9060 | 1.91 | | | [2009-12-06 Sun] | 2077.6757 | 1.5923 | 1.59 | | | [2009-12-13 Sun] | 2079.2140 | 1.5383 | 1.54 | | | [2009-12-20 Sun] | 2081.4222 | 2.2082 | 2.21 | | | [2009-12-27 Sun] | 2083.2146 | 1.7924 | 1.79 | | | [2010-01-03 Sun] | 2085.4916 | 2.2770 | 2.28 | | | [2010-01-10 Sun] | 2087.4283 | 1.9367 | 1.94 | | ^ | | | | Eau | #+TBLFM: $4=3D@+0$-1-@-1$-1;%.4f::$5=3D$4*1;%.2f::@2$4=3D0;%.4f | =C3=89nergie | Prix TVAC | |-------------+-----------| | Eau | 1.94 | | Gaz | 156.81 | | =C3=89lectricit=C3=A9 | 11.64 | |-------------+-----------| | Total | 170.39 | #+TBLFM: @2$2=3Dremote(Eau,$Eau)::@3$2=3Dremote(Gaz,$Gaz)::@4$2=3Dremote(= Elec,$Elec)::@5$2=3Dvsum(@-I..@-II);%.2f Best regards, Seb --=20 S=C3=A9bastien Vauban _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode-mXXj517/zsQ@public.gmane.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode