From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.brand@alumni.ethz.ch>
Subject: Re: Re: Can't import a remote reference to a whole column in orgtbl
Date: Sun, 04 Apr 2010 21:02:40 +0200
Message-ID: <4BB8E250.8090404@alumni.ethz.ch>
References: <82e274891002251643k327135aajea270914244abff7@mail.gmail.com>
	<82e274891002251654s643e8003pdb2b3db669d5528b@mail.gmail.com>
	<83d3zs8hya.fsf@yahoo.it>
	<x2q82e274891004031024m3b047758tbf4195b96cc21607@mail.gmail.com>
	<789851DE-3D35-4623-AB0A-E4168A5A178E@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1NyV5s-00034i-4U
	for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 15:02:48 -0400
Received: from [140.186.70.92] (port=33936 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1NyV5q-00034a-VG
	for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 15:02:47 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69)
	(envelope-from <michael.brand@alumni.ethz.ch>) id 1NyV5p-0008L5-3n
	for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 15:02:46 -0400
Received: from mail05.solnet.ch ([212.101.4.139]:62601)
	by eggs.gnu.org with esmtp (Exim 4.69)
	(envelope-from <michael.brand@alumni.ethz.ch>) id 1NyV5o-0008K2-Uh
	for emacs-orgmode@gnu.org; Sun, 04 Apr 2010 15:02:45 -0400
In-Reply-To: <789851DE-3D35-4623-AB0A-E4168A5A178E@gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Carsten Dominik <carsten.dominik@gmail.com>
Cc: Org-Mode List <emacs-orgmode@gnu.org>

Carsten Dominik wrote:
>> 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 inefficient.  
> To copy column 2 from table FOO into column 3 of the current table, use
> 
>  #+TBLFM: $3=remote(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.

Very nice use case for `@#'. How about a doc update somehow like this?

=============================================================================
--- a/doc/org.texi
+++ b/doc/org.texi
@@ -2061,10 +2061,15 @@ see the @samp{E} mode switch below).  If
  For Calc formulas and Lisp formulas @code{@@#} and @code{$#} can be used to
  get the row or column number of the field where the formula result goes.
  The traditional Lisp formula equivalents are @code{org-table-current-dline}
-and @code{org-table-current-column}.  Example:
+and @code{org-table-current-column}.  Examples:

  @example
-if(@@# % 2, $#, string(""))      @r{column number on odd lines only}
+if(@@# % 2, $#, string(""))   @r{column number on odd lines only}
+$3 = remote(FOO, @@@@#$2)      @r{copy column 2 from table FOO into}
+                             @r{column 3 of the current table@footnote{Both
+tables must have the same count of rows.  Inefficient for a large count N of
+rows with a time complexity of O(N^2) because all rows of the FOO table will
+be parsed again for each field to be copied.}}
  @end example

  @subsubheading Named references
=============================================================================