From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: Question regarding remote references in tables
Date: Wed, 16 Nov 2011 11:40:00 -0500
Message-ID: <32485.1321461600@alphaville.dokosmarshall.org>
References: <20111116152719.GA7227@client195-107.wlan.hu-berlin.de>
	<31114.1321458741@alphaville.dokosmarshall.org>
Reply-To: nicholas.dokos@hp.com
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:41012)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RQiWw-0003Pf-72
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 11:40:15 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RQiWq-0001c5-FI
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 11:40:10 -0500
Received: from g1t0029.austin.hp.com ([15.216.28.36]:3664)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nick@dokosmarshall.org>) id 1RQiWq-0001bQ-6I
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 11:40:04 -0500
Received: from g1t0039.austin.hp.com (g1t0039.austin.hp.com [16.236.32.45])
	by g1t0029.austin.hp.com (Postfix) with ESMTP id 3CBAF38077
	for <emacs-orgmode@gnu.org>; Wed, 16 Nov 2011 16:40:02 +0000 (UTC)
In-Reply-To: Message from Nick Dokos <nicholas.dokos@hp.com> of "Wed,
	16 Nov 2011 10:52:21 EST."
	<31114.1321458741@alphaville.dokosmarshall.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org
Cc: nicholas.dokos@hp.com

Nick Dokos <nicholas.dokos@hp.com> wrote:

> Viktor Rosenfeld <listuser36@googlemail.com> wrote:
> 
> > Hi,
> > 
> > I'm trying to copy the values of a column in one table to another table
> > in. If I understand the manual correctly, this should be possible with
> > remote references. But I can't get it to work. In the example below, if
> > I evaluate the table formula, column 2 of table "bar" is copied into
> > column 3.
> > 
> > Cheers,
> > Viktor
> > 
> > * Source table
> > 
> > #+TBLNAME: foo
> > | Query | Time |
> > |-------+------|
> > |     1 |  123 |
> > |     2 |  234 |
> > |     3 |  345 |
> > 
> > * Reference table
> > 
> > #+TBLNAME: bar
> > | Query | Garbage | Old Time |
> > |-------+---------+----------|
> > |     1 | a       |          |
> > |     2 | b       |          |
> > |     3 | c       |          |
> > #+TBLFM: $3=remote(foo,$2)
> > 
> 
> The manual says:
> 
>      $3 = remote(FOO, @@#$2)      copy column 2 from table FOO into
>                                   column 3 of the current table
> 
> and that works.
> 

A quick look shows (modulo mistakes) that the difference is that the
second form matches org-table-range-regexp, whereas the first one does
not: I'm not sure if that changed recently and/or whether it's
deliberate.

Nick