From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Referencing elemts of a table Date: Tue, 7 Jun 2011 19:22:29 +0200 Message-ID: References: <2011-06-07T17-53-32@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:46184) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QTzz8-0004ae-7n for emacs-orgmode@gnu.org; Tue, 07 Jun 2011 13:22:35 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QTzz5-0001lS-OM for emacs-orgmode@gnu.org; Tue, 07 Jun 2011 13:22:33 -0400 Received: from mail-ew0-f41.google.com ([209.85.215.41]:50708) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QTzz5-0001lG-Ab for emacs-orgmode@gnu.org; Tue, 07 Jun 2011 13:22:31 -0400 Received: by ewy9 with SMTP id 9so2077538ewy.0 for ; Tue, 07 Jun 2011 10:22:30 -0700 (PDT) In-Reply-To: <2011-06-07T17-53-32@devnull.Karl-Voit.at> 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: news1142@karl-voit.at Cc: emacs-orgmode@gnu.org Hi Karl You need additionally $# from "Field coordinates in formulas" described her= e: http://orgmode.org/manual/References.html#References and Calc vector subscript: #+TBLFM: @2 =3D subscr(remote(orgtblA, @2$2..@2$7), $#) Michael On Tue, Jun 7, 2011 at 17:55, Karl Voit wrote: > I want to define "orgtblB line 2 (row 1 to 6)" should contain the > values "from orgtblA, last line, row 2 to 7". > > I tried > > =A0 =A0#+TBLFM: @2=3Dremote(orgtblA,@2$2..@2$7) > > and > > =A0 =A0#+TBLFM: @2$1..@2$6=3Dremote(orgtblA,@2$2..@2$7) > > but that results in a list of 6x 5 values in each field in row 2. > > Here is an example of my org-tbl-reference-problem: > http://paste.grml.org/462/