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

["Ismael Barros²" <razielmine@gmail.com>]

This would probably help:

Source table:

#+TBLNAME: results_par
#+ORGTBL: SEND results_par orgtbl-to-latex :splice t :skip 2
  |   | proc |    t1 |       |    t2 |       |      |   t3 |       |      |
  |---+------+-------+-------+-------+-------+------+------+-------+------|
  | # |    1 |  1.72 |  1.72 | 60.21 |  0.89 | 0.89 | 8.84 |  0.87 | 0.87 |
  | # |    2 | 32.66 | 16.33 | 30.37 |  1.77 | 0.89 | 4.41 |  1.74 | 0.87 |
  | # |    4 | 37.26 |  9.31 | 15.63 |  3.44 | 0.86 | 2.22 |  3.45 | 0.86 |
  | # |    8 | 36.36 |  4.54 |  8.12 |  6.62 | 0.83 | 1.11 |  6.90 | 0.86 |
  | # |   16 | 38.90 |  2.43 |  4.38 | 12.28 | 0.77 | 0.56 | 13.68 | 0.85 |
#+TBLFM: $3=$0;%.2f :: $4=@$-1/@$2;%.2f ::
                            $5=$0;%.2f ::
$6=remote(results_seq,@2$1)/@$-1;%.2f :: $7=@$-1/@$2;%.2f ::        \
        $8=$0;%.2f :: $9=remote(results_seq,@2$2)/@$-1;%.2f :: $10=@$-1/@$2;%.2f
  % $


Destination table:

#+ORGTBL: SEND results1_2 orgtbl-to-latex :splice t :skip 2
  |   | proc |    t1 |      |      |    t2 |      |      |   t3 |      |      |
  |---+------+-------+------+------+-------+------+------+------+------+------|
  | # |    1 |  1.59 | 1.00 | 1.00 | 40.05 | 0.02 | 0.02 | 8.34 | 8.34 | 8.34 |
  | # |    2 | 37.28 | 1.00 | 0.50 | 20.29 | 0.02 | 0.01 | 4.17 | 4.17 | 2.08 |
  | # |    4 | 34.91 | 1.00 | 0.25 | 10.43 | 0.02 | 0.01 | 2.13 | 2.13 | 0.53 |
  | # |    8 | 36.36 | 1.00 | 0.12 |  5.42 | 0.02 | 0.00 | 1.05 | 1.05 | 0.13 |
  | # |   16 | 38.93 | 1.00 | 0.06 |  3.03 | 0.02 | 0.00 | 0.53 | 0.53 | 0.03 |
#+TBLFM: $3=$0;%.2f :: $4=remote(results_par,$3)/@$-1;%.2f ::
$5=@$-1/@$2;%.2f ::                 $6=$0;%.2f ::
$7=remote(results_par,$5)/@$-1;%.2f :: $8=@$-1/@$2;%.2f ::           \
      $9=$0;%.2f :: $10=remote(results_par,$9);%.2f :: $11=@$-1/@$2;%.2f
  % $

Note how $10=remote(results_par,$9) yields $10=$9.

Also, this happened on org-mode 6.34c-5 and org-mode from git.

Regards,
Ismael

On Fri, Feb 26, 2010 at 1:43 AM, Ismael Barros² <razielmine@gmail.com> wrote:
> 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 :)
>
> 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, with "remote(results_par,$9)", it doesn't work: instead
> of column 9 from "results_par" table, I get column 9 from the table
> I'm woking on.
>
> Am I doing something wrong or did I stumble with a bug in orgtbl? Any
> workaround or version that has it fixed? I would *really* appreciate
> some help, deadlines are crushing me!
>
> Regards, and thanks in advance!
> Ismael
>