From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: remote reference Date: Wed, 12 May 2010 15:06:38 +0200 Message-ID: References: <2ACD6FB3-B415-4AE7-8D62-9450922514D0@gmail.com> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from [140.186.70.92] (port=56879 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OCCU5-0000RY-So for emacs-orgmode@gnu.org; Wed, 12 May 2010 10:00:26 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OCCU3-0003dd-Bx for emacs-orgmode@gnu.org; Wed, 12 May 2010 10:00:25 -0400 Received: from mail-ew0-f216.google.com ([209.85.219.216]:51789) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OCCU3-0003cl-4x for emacs-orgmode@gnu.org; Wed, 12 May 2010 10:00:23 -0400 Received: by mail-ew0-f216.google.com with SMTP id 8so20697ewy.8 for ; Wed, 12 May 2010 07:00:22 -0700 (PDT) In-Reply-To: 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: Karl Eichwalder Cc: emacs-orgmode@gnu.org Fixed, thanks. - Carsten On May 12, 2010, at 1:26 PM, Karl Eichwalder wrote: > Carsten Dominik writes: > >> On May 11, 2010, at 9:16 PM, Karl Eichwalder wrote: >>> C-c C-c in a TBLFM with a remote table reference updates the table >>> as >>> expected, but also jumps to the referenced table in the remote file. >>> Is >>> this intended? If yes, is it possible to avoid it? >> >> Can you please be more specific. What exactly happens? > > Consider the following two files: > > * 2009 > #+TBLNAME: 2009 > :PROPERTIES: > :ID: ea32e5b5-31ba-468e-8e31-3e0d09696bb0 > :END: > |-----+-------| > | mm | km | > |-----+-------| > | all | 946.8 | > |-----+-------| > > * 2010 > #+TBLNAME: 2010 > :PROPERTIES: > :ID: e0df84c4-8abc-458f-a1ee-eb53eb71b4f0 > :END: > |-----+-------+-------+-------| > | mm | km | B km | G km | > |-----+-------+-------+-------| > | all | 249.4 | 429.2 | 678.6 | > |-----+-------+-------+-------| > > * all > :PROPERTIES: > :ID: 44751a7f-73a4-4c07-b3c2-e3edb9042acd > :END: > #+TBLNAME: all > |------+--------| > | yyyy | km | > |------+--------| > | 2009 | | > | 2010 | 678.6 | > |------+--------| > | all | 1625.4 | > |------+--------| > #+TBLFM: @2$2=remote(ea32e5b5-31ba-468e-8e31-3e0d09696bb0,$LR2);%. > 1f::@3$2=remote(2010,$LR4);%.1f::$LR2=vsum(@2$2..@-1);%.1f > > Then, in the 2010 file, eval the formula of the "all" table by > pressing > C-c C-c. > ==> > > It takes the km value from the 2009 file, but also puts the cursor > (point) into the 2009 file in front of the ID: > > * 2009 > #+TBLNAME: 2009 > :PROPERTIES: > :ID: -!-ea32e5b5-31ba-468e-8e31-3e0d09696bb0 > :END: > |-----+-------| > | mm | km | > |-----+-------| > | all | 946.8 | > |-----+-------| > > -=-=-=-=-=-=-=-=-=-=-=-=-=- cut here -=-=-=-=-=-=-=-=-=-=-=-=-=- > > I'd prefer if the point would stay in the 2010 file. > > -- > Karl Eichwalder > - Carsten