at 18:52, Wu Ming 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.
&g
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.
> On 12 Mar 2024, at 22:46, Ihor Radchenko wrote:
>
> Wu Ming writes:
>
>> Problem solved with
>>
>> $1 = remote(A,@@#$1)
>>
>> as described on the manual page
>> https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1
> On 14 Mar 2024, at 9:40 PM, Fraga, Eric wrote:
>
> On Thursday, 14 Mar 2024 at 09:16, Wu Ming wrote:
>> Unrelated, but appeared on the same trial, noticed a cell was
>> mis-calculated. [...] This made me worry about reliability of simple
>> biz calculations I a
> On 15 Mar 2024, at 2:58 AM, Ihor Radchenko wrote:
>
> Wu Ming writes:
>
>>> See "Remote references" subsection. It explains that in
>>> remote(NAME,REF), REF is inside the remote table. Relative and current
>>> column/row is ambiguous t
> On 13 Mar 2024, at 20:16, Ihor Radchenko wrote:
>
> Wu Ming writes:
>
>> My fault. Missed the line "One of the very first actions during evaluation
>> of Calc formulas and Lisp formulas is to substitute ‘@#’ and ‘$#’ in the
>> formula with the row
