From: Carsten Dominik <carsten.dominik@gmail.com>
To: "Ismael Barros²" <razielmine@gmail.com>,
"Michael Brand" <michael.brand@alumni.ethz.ch>
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, 4 Apr 2010 08:47:56 +0200 [thread overview]
Message-ID: <789851DE-3D35-4623-AB0A-E4168A5A178E@gmail.com> (raw)
In-Reply-To: <x2q82e274891004031024m3b047758tbf4195b96cc21607@mail.gmail.com>
On Apr 3, 2010, at 7:24 PM, Ismael Barros² 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
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.
HTH
- Carsten
>
> Regards,
> Ismael
>
> On Fri, Feb 26, 2010 at 10:27 AM, Giovanni Ridolfi
> <giovanni.ridolfi@yahoo.it> wrote:
>>> Ismael Barros² <razielmine@gmail.com> writes:
>>
>> Hi, Ismael
>>
>>>> Hi, I'm new to org-mode and orgtbl, please don't hit me too hard
>>>> 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
next prev parent reply other threads:[~2010-04-04 6:48 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 [this message]
2010-04-04 19:02 ` Michael Brand
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:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=789851DE-3D35-4623-AB0A-E4168A5A178E@gmail.com \
--to=carsten.dominik@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=michael.brand@alumni.ethz.ch \
--cc=razielmine@gmail.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* 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 external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.