From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniel Gerber <daniel.g.gerber@gmail.com>
Subject: Spreadsheet - issue with remote reference to named column
Date: Thu, 10 Sep 2015 15:06:50 +0200
Message-ID: <55F1806A.2020201@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:60717)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <daniel.g.gerber@gmail.com>) id 1Za1Z5-00035X-UM
	for emacs-orgmode@gnu.org; Thu, 10 Sep 2015 09:07:00 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <daniel.g.gerber@gmail.com>) id 1Za1Z2-0000cP-Nx
	for emacs-orgmode@gnu.org; Thu, 10 Sep 2015 09:06:59 -0400
Received: from mail-wi0-x22c.google.com ([2a00:1450:400c:c05::22c]:34474)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <daniel.g.gerber@gmail.com>) id 1Za1Z2-0000YO-DV
	for emacs-orgmode@gnu.org; Thu, 10 Sep 2015 09:06:56 -0400
Received: by wicfx3 with SMTP id fx3so27428323wic.1
	for <emacs-orgmode@gnu.org>; Thu, 10 Sep 2015 06:06:52 -0700 (PDT)
Received: from [192.168.0.21] (80-218-233-20.dclient.hispeed.ch.
	[80.218.233.20]) by smtp.gmail.com with ESMTPSA id
	12sm15644819wjw.15.2015.09.10.06.06.50 for <emacs-orgmode@gnu.org>
	(version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128);
	Thu, 10 Sep 2015 06:06:50 -0700 (PDT)
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,

The docs say that the REF argument to remote can be "@3$3 or $somename, 
valid in the referenced table". So, adapting the tutorial, the last 
column here should get the same values as the second one, right?


| currency | rate (@r$c ref) | rate (named ref) |
|----------+-----------------+------------------|
| eur      |               1 | nil              |
| usd      |            0.77 | nil              |
| sek      |            0.12 | nil              |
| sek      |            0.12 | nil              |
| sek      |            0.12 | nil              |
| nok      |            0.14 | nil              |
|          |             nil |                  |
  #+TBLFM: $2='(org-lookup-first $1 '(remote(rates,@2$2..@>$2)) 
'(remote(rates,@2$3..@>$3)))::$3='(org-lookup-first $1 
'(remote(rates,$abbr)) '(remote(rates,$euros)))


  #+TBLNAME: rates
| ! | abbr | euros |
|---+------+-------|
|   | eur  |     1 |
|   | nok  |  0.14 |
|   | sek  |  0.12 |
|   | usd  |  0.77 |



Thanks for your answers!


Daniel