Re: [Orgmode] Re: Can't import a remote reference to a whole column in orgtbl

[Carsten Dominik]

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
> <address@hidden> wrote:
> > > Ismael Barros² <address@hidden> 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.
> address@hidden
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten