emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Michael Brand <michael.brand@alumni.ethz.ch>
To: Carsten Dominik <carsten.dominik@gmail.com>
Cc: Org-Mode List <emacs-orgmode@gnu.org>
Subject: Re: Re: Can't import a remote reference to a whole column in orgtbl
Date: Sun, 04 Apr 2010 21:02:40 +0200	[thread overview]
Message-ID: <4BB8E250.8090404@alumni.ethz.ch> (raw)
In-Reply-To: <789851DE-3D35-4623-AB0A-E4168A5A178E@gmail.com>

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:

-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

  reply	other threads:[~2010-04-04 19:02 UTC|newest]

Thread overview: 14+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2010-02-26  0:43 Can't import a remote reference to a whole column in orgtbl Ismael Barros²
2010-02-26  0:54 ` Ismael Barros²
2010-02-26  9:27   ` Giovanni Ridolfi
2010-04-03 17:24     ` Ismael Barros²
2010-04-04  6:47       ` Carsten Dominik
2010-04-04 19:02         ` Michael Brand [this message]
2010-04-04 20:08           ` Carsten Dominik
2010-04-05  6:11             ` Michael Brand
2010-04-05  6:48               ` Carsten Dominik
2010-04-05 18:26                 ` Michael Brand
2010-04-06  5:15                   ` Carsten Dominik
2010-04-07 19:55                     ` Michael Brand
2011-11-01 21:14                       ` [Orgmode] " Nick Dokos
2011-11-01 21:23                       ` Nick Dokos

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=4BB8E250.8090404@alumni.ethz.ch \
    --to=michael.brand@alumni.ethz.ch \
    --cc=carsten.dominik@gmail.com \
    --cc=emacs-orgmode@gnu.org \


* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox


This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).