From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: Re: Can't import a remote reference to a whole column in orgtbl Date: Sun, 4 Apr 2010 08:47:56 +0200 Message-ID: <789851DE-3D35-4623-AB0A-E4168A5A178E@gmail.com> References: <82e274891002251643k327135aajea270914244abff7@mail.gmail.com> <82e274891002251654s643e8003pdb2b3db669d5528b@mail.gmail.com> <83d3zs8hya.fsf@yahoo.it> Mime-Version: 1.0 (Apple Message framework v936) Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NyJcp-0003GI-32 for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 02:48:03 -0400 Received: from [140.186.70.92] (port=42555 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NyJco-0003Ew-01 for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 02:48:02 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NyJcl-00045L-Od for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 02:48:01 -0400 Received: from mail-ew0-f214.google.com ([209.85.219.214]:50831) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NyJcl-00045A-Ic for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 02:47:59 -0400 Received: by ewy6 with SMTP id 6so207933ewy.32 for ; Sat, 03 Apr 2010 23:47:58 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: =?ISO-8859-1?Q?Ismael_Barros=B2?= , Michael Brand Cc: Org-Mode List On Apr 3, 2010, at 7:24 PM, Ismael Barros=B2 wrote: > My bad, I should have googled harder :) > > Just out of curiosity: is this limitation there by design, or is it > waiting for some workforce to complete it? I finally just copy+pasted > the columns I needed, but being able to import whole rows/columns > would be incredibly useful. There is actually now a way to do tis - even though it is =20 inefficient. To copy column 2 from table FOO into column 3 of the =20 current table, use #+TBLFM: $3=3Dremote(FOO,@@#$2) This is now possible due to a patch by Michael Brand: http://thread.gmane.org/gmane.emacs.orgmode/22930 It works well, but it is inefficient because this formula will parse the FOO table again for each field to be copied. HTH - Carsten > > Regards, > Ismael > > On Fri, Feb 26, 2010 at 10:27 AM, Giovanni Ridolfi > wrote: >>> Ismael Barros=B2 writes: >> >> Hi, Ismael >> >>>> Hi, I'm new to org-mode and orgtbl, please don't hit me too hard =20= >>>> with >>>> a stick if what I'm asking is retarded :) >> well a google search would have shown >> http://comments.gmane.org/gmane.emacs.orgmode/21439 >> ;-) >> >>>> >>>> I'm using org-mode with orgtbl inside a Latex document. I'm making >>>> extensive use of remote references to other tables inside the >>>> document. >>>> If I reference a cell, for example, with >>>> "remote(results_par,@2$9)", it works as expected, >>>> but if I reference a whole column, >> >> You cannot. This is the answer by Carsten: >> >> "ranges are possible in remote references. However, what >> is not allowed it to assign them to a range. On the left >> side of equations you can only have single fields >> like @2$3 or a column like $3. >> >> So you might ask what the use of range references then >> is? You can put the ranges into calc functions like >> vsum or vmean, or you can get them as lists in an >> elisp formula." >> >> >> cheers, >> Giovanni >> > > > _______________________________________________ > Emacs-orgmode mailing list > Please use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode - Carsten