From mboxrd@z Thu Jan 1 00:00:00 1970 From: kinouchou Subject: Re: Referencing elemts of a table Date: Wed, 8 Jun 2011 02:05:51 +0200 Message-ID: References: <2011-06-07T17-53-32@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=0016e6538666762d9e04a52819cf Return-path: Received: from eggs.gnu.org ([140.186.70.92]:39697) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QU6HR-0005S7-HC for emacs-orgmode@gnu.org; Tue, 07 Jun 2011 20:05:54 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QU6HQ-0001Rf-9u for emacs-orgmode@gnu.org; Tue, 07 Jun 2011 20:05:53 -0400 Received: from mail-qw0-f41.google.com ([209.85.216.41]:43725) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QU6HQ-0001Rb-7e for emacs-orgmode@gnu.org; Tue, 07 Jun 2011 20:05:52 -0400 Received: by qwa26 with SMTP id 26so12244qwa.0 for ; Tue, 07 Jun 2011 17:05:51 -0700 (PDT) In-Reply-To: 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 --0016e6538666762d9e04a52819cf Content-Type: text/plain; charset=UTF-8 Hello, Do you know if it's possible for a table in another file? Because in the manuel i read it's possible but I don't have result. (sorry for my english) Christelle On Tue, Jun 7, 2011 at 7:22 PM, Michael Brand wrote: > Hi Karl > > You need additionally $# from "Field coordinates in formulas" described > here: > http://orgmode.org/manual/References.html#References > and Calc vector subscript: > #+TBLFM: @2 = 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 > > > > #+TBLFM: @2=remote(orgtblA,@2$2..@2$7) > > > > and > > > > #+TBLFM: @2$1..@2$6=remote(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/ > > --0016e6538666762d9e04a52819cf Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hello,

Do you know if it's possible for a table in another file?= Because in the manuel i read it's possible but I don't have result= .

(sorry for my english)
Christelle


On Tue, Jun 7, 2011 at 7:22 PM, Michael Brand <michael.ch.brand@gmail.com> wrote:
Hi Karl

You need additionally $# from "Field coordinates in formulas" des= cribed here:
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 <devnull@karl-voit.at> wrote:
> I want to define "orgtblB line 2 (row 1 to 6)" should contai= n the
> values "from orgtblA, last line, row 2 to 7".
>
> I tried
>
> =C2=A0 =C2=A0#+TBLFM: @2=3Dremote(orgtblA,@2$2..@2$7)
>
> and
>
> =C2=A0 =C2=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/


--0016e6538666762d9e04a52819cf--