From mboxrd@z Thu Jan 1 00:00:00 1970 From: Volker Strobel Subject: Relative Remote Reference (column->row) Date: Fri, 21 Mar 2014 01:31:36 +0100 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=f46d044787912ead2f04f5130299 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:41121) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WQnN4-00034C-TK for emacs-orgmode@gnu.org; Thu, 20 Mar 2014 20:31:39 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WQnN3-0005GV-SU for emacs-orgmode@gnu.org; Thu, 20 Mar 2014 20:31:38 -0400 Received: from mail-ob0-x232.google.com ([2607:f8b0:4003:c01::232]:34434) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WQnN3-0005GP-NO for emacs-orgmode@gnu.org; Thu, 20 Mar 2014 20:31:37 -0400 Received: by mail-ob0-f178.google.com with SMTP id wp18so1790370obc.23 for ; Thu, 20 Mar 2014 17:31:36 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 --f46d044787912ead2f04f5130299 Content-Type: text/plain; charset=ISO-8859-1 Hi there, I'm trying to refer to the row number of a remote table, using the current column number shifted by one. Remote Table: #+NAME: my-table | Header1 | Header2 | |---------+---------| | a | 23 | | b | 7 | | c | 13 | | d | 66 | | e | 5 | |---------+---------| | Result | 42 | Table where remote value should be inserted: ... #+TBLFM: @1$3..@1$7= remote(my-table,@$#$2) My problem is, that this remote reference starts in row 3 (because of @$#), however, I'd like to start in row 2 (that means @$#-1). However, this relative reference does not seem to work here. Any idea what command I can use here? Thanks! Best, Volker --f46d044787912ead2f04f5130299 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi there,

I'm trying to refer t= o the row number of a remote table, using the current column number shifted= by one.=A0

Remote Table:
#+NAME: my-table
| Heade= r1 | Header2 |
|---------+---------|
|=A0=A0 a=A0=A0=A0=A0 |=A0=A0=A0 23=A0 |
|=A0= =A0 b=A0=A0=A0=A0 |=A0=A0=A0 7=A0=A0=A0 |
|=A0=A0 c=A0=A0=A0=A0 |=A0=A0= =A0 13=A0 |
|=A0=A0 d=A0=A0=A0=A0 |=A0=A0=A0 66=A0 |
|=A0=A0 e=A0=A0= =A0=A0 |=A0=A0=A0 5=A0=A0=A0 |
|---------+---------|
| Result=A0 |=A0= 42 |


Table where remote value should be inserted: ...
#+TBLFM: @1$3..@1$7=3D remote(my-table,@$#$2)
My problem is, that this remote reference starts in row 3 = (because of @$#), however, I'd like to start in row 2 (that means @$#-1= ). However, this relative reference does not seem to work here.

Any idea what command I can use here?

Than= ks!

Best, Volker
--f46d044787912ead2f04f5130299--