Re: [O] Question regarding remote references in tables

[Nick Dokos]

Nick Dokos <address@hidden> wrote:

> Viktor Rosenfeld <address@hidden> wrote:
> 
> > Hi,
> > 
> > I'm trying to copy the values of a column in one table to another table
> > in. If I understand the manual correctly, this should be possible with
> > remote references. But I can't get it to work. In the example below, if
> > I evaluate the table formula, column 2 of table "bar" is copied into
> > column 3.
> > 
> > Cheers,
> > Viktor
> > 
> > * Source table
> > 
> > #+TBLNAME: foo
> > | Query | Time |
> > |-------+------|
> > |     1 |  123 |
> > |     2 |  234 |
> > |     3 |  345 |
> > 
> > * Reference table
> > 
> > #+TBLNAME: bar
> > | Query | Garbage | Old Time |
> > |-------+---------+----------|
> > |     1 | a       |          |
> > |     2 | b       |          |
> > |     3 | c       |          |
> > #+TBLFM: $3=remote(foo,$2)
> > 
> 
> The manual says:
> 
>      $3 = remote(FOO, @@#$2)      copy column 2 from table FOO into
>                                   column 3 of the current table
> 
> and that works.
> 

A quick look shows (modulo mistakes) that the difference is that the
second form matches org-table-range-regexp, whereas the first one does
not: I'm not sure if that changed recently and/or whether it's
deliberate.

Nick