Re: Table column formula with remote reference

[Ihor Radchenko]

Wu Ming <wu.ming2@icloud.com> 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 or column number of the field where the current result will go 
> to.“  So '@@#' becomes '@<current row>'. 
>
> Overlooked it also because I did read the other line "‘@0’ and ‘$0’ refer to 
> the current row and column, respectively, i.e., to the row/column for the 
> field being computed.” and did try '@0$1'. Why is this different from the 
> above?

See "Remote references" subsection. It explains that in
remote(NAME,REF), REF is inside the remote table. Relative and current
column/row is ambiguous there.

In contrast, @# and $# are special - they are replaced before
remote(...) is processed.

I agree that the manual is somewhat confusing. Possibly, we may even
change `org-table-get-remote-range' to use relative references according
to the original table. Improvements welcome!

-- 
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>