From mboxrd@z Thu Jan  1 00:00:00 1970
From: Viktor Rosenfeld <listuser36@googlemail.com>
Subject: Question regarding remote references in tables
Date: Wed, 16 Nov 2011 16:27:19 +0100
Message-ID: <20111116152719.GA7227@client195-107.wlan.hu-berlin.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:34005)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <listuser36@googlemail.com>) id 1RQhOa-000250-Gg
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 10:27:29 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <listuser36@googlemail.com>) id 1RQhOW-0002ay-GF
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 10:27:28 -0500
Received: from mail-bw0-f41.google.com ([209.85.214.41]:62927)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <listuser36@googlemail.com>) id 1RQhOW-0002am-6C
	for emacs-orgmode@gnu.org; Wed, 16 Nov 2011 10:27:24 -0500
Received: by bke17 with SMTP id 17so848057bke.0
	for <emacs-orgmode@gnu.org>; Wed, 16 Nov 2011 07:27:22 -0800 (PST)
Content-Disposition: inline
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

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)

* Expected

| Query | Garbage | Old Time |
|-------+---------+----------|
|     1 | a       |      123 |
|     2 | b       |      234 |
|     3 | c       |      345 |

* Produced

| Query | Garbage | Old Time |
|-------+---------+----------|
|     1 | a       | a        |
|     2 | b       | b        |
|     3 | c       | c        |