Wu Ming <wu.mi...@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>
