Re: Table column formula with remote reference

[Wu Ming]

Problem solved with

$1 = remote(A,@@#$1)

as described on the manual page https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1

Where is the coordinate @@# documented?

On 11 Mar 2024, at 18:52, Wu Ming <wu.ming2@icloud.com> wrote:

Hello,

#+NAME: A
Table with header row here

#+NAME: B
Table with header row here
#+TBLFML: $1 = remote(A,$1)

Does nothing.

$1 = remote(A,@0) referring current row w implicit column does not work. Debug shows on row 2 of current table it returns the value of row 1, the header, on table A.

Same result as above with @0$1 instead.

$1 = remote(A,@2$1) does what expected. For every row copies the same value of @2$1 from table A to table B.

Need to refer multiple columns on different tables in a column formula for a final table.

Please advise. Thanks.