Re: Table column formula with remote reference

On Sunday, 17 Mar 2024 at 10:29, Wu Ming wrote: > Haven’t tried Org export options yet. What is your organization system > with tables? I don't have a system! Often, tables in my documents are the output of some other code and the tables are the results that need further processing (or

Re: Table column formula with remote reference

Wu Ming writes: > Very clear now. Thank you. But I was mostly confounded by references > $0 and #0 versus the @@# (and $$#) you just described the processing > of. Don’t want to abuse your time. I can figure it out when needed. > But if you feel inclined to unravel this little detail of the

Re: Table column formula with remote reference

> 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 there. >>> >>> In contrast, @# and $# are special -

Re: Table column formula with remote reference

> 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 am trying on Org spreadsheet

Re: Table column formula with remote reference

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 there. >> >> In contrast, @# and $# are special - they are replaced before >> remote(...) is processed. > ... > I have

Re: Table column formula with remote reference

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 am trying on Org spreadsheet for the first > time. Please advise. I've not seen any

Re: Table column formula with remote reference

> 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 or column number of the field where the

Re: Table column formula with remote reference

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 or column number of the field where the current result will go > to.“ So '@@#' becomes '@'. > >

Re: Table column formula with remote reference

> 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 >>

Re: Table column formula with remote reference

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 > > > Where is the coordinate @@#

Re: Table column formula with remote reference

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