From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: remote reference Date: Fri, 15 Jan 2010 16:55:07 +0100 Message-ID: <6D5CED20-6E3E-4FFA-BB8E-89AA119E3317@gmail.com> References: <2ACD6FB3-B415-4AE7-8D62-9450922514D0@gmail.com> <83ockvbr0t.fsf@yahoo.it> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NVoW6-0005zV-QX for emacs-orgmode@gnu.org; Fri, 15 Jan 2010 10:55:18 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1NVoW2-0005um-C6 for emacs-orgmode@gnu.org; Fri, 15 Jan 2010 10:55:18 -0500 Received: from [199.232.76.173] (port=58996 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NVoW1-0005uf-VU for emacs-orgmode@gnu.org; Fri, 15 Jan 2010 10:55:14 -0500 Received: from mail-ew0-f209.google.com ([209.85.219.209]:46199) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1NVoW0-0001pR-JX for emacs-orgmode@gnu.org; Fri, 15 Jan 2010 10:55:13 -0500 Received: by ewy1 with SMTP id 1so160107ewy.8 for ; Fri, 15 Jan 2010 07:55:10 -0800 (PST) In-Reply-To: <83ockvbr0t.fsf@yahoo.it> 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: Giovanni Ridolfi Cc: =?ISO-8859-1?Q?S=E9bastien_Vauban?= , org-mode mailing list Hi Giovanni, ranges are possible in remote references. However, what is not allowed it to assign them to a range. On the left side of equations you can only have single fields like @2$3 or a column like $3. So you might ask what the use of range references then is? You can put the ranges into calc functions like vsum or vmean, or you can get them as lists in an elisp formula. Hope this clarifies it a bit.... Looks like someone needs to write a tutorial about that! :-) - Carsten On Jan 15, 2010, at 11:29 AM, Giovanni Ridolfi wrote: > > Carsten, > > I cannot reference fields in tables as the manual says. > Org-mode version 6.34 > GNU Emacs 23.1.1 (i386-mingw-nt5.1.2600) of 2009-07-30 on SOFT-MJASON > > Example: > ------------------------------------------------- > * [2010-01-15 ven] table & reference > ** table a > #+TBLNAME: Taba > | | # | x | y | > |---+---+----+---| > | | 1 | -2 | 4 | > | | 2 | -1 | 1 | > | | 3 | 0 | 0 | > | | 4 | 1 | 1 | > | | 5 | 2 | 4 | > | ^ | | | a | > ** table b > the manual says: > : remote(NAME-OR-ID,REF) > : REF is an absolute field or range reference > : as described above for example `@3$3' or `$somename', valid in the > : referenced table. > > But I found that as a REF I can only use: > + field a cell @5$1=remote(Taba,$a) > + and *NOT* range reference (as $somename) or > ranges such as @1$2..@5$2, > but in the manual is not explicitly said. > So I could have misunderstoot the meaning of "range". > > See the non working examples: > *** variables > #+TBLNAME: Tabb > | | | > |---+---| > | ^ | b | > #+TBLFM: $b=remote(Taba,$a) > *** columns > #+TBLNAME: Tabc > | | | > | | | > | | | > | | | > | | | > |---+---| > | ^ | b | > #+TBLFM: $2=remote(Taba,$4) > > #+TBLNAME: Tabcc > | | | > | | | > | | | > | | | > | | | > |---+---| > | ^ | b | > #+TBLFM: @1$2..@5$2=remote(Taba,$4) > *** ranges: > #+TBLNAME: Tabr > | | | > | | | > | | | > | | | > | | | > |---+---| > | ^ | b | > #+TBLFM: @1$2..@5$2=remote(Taba,@1$3..@5$3) > ------------------------------------------------------------ > Is my analysis correct? > Did I misunderstand the meanong of "range"? > Is the documentation incomplete? > Is there a bug and the documentation is correct? > > cheers, > Giovanni > > > _______________________________________________ > Emacs-orgmode mailing list > Please use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode - Carsten