From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms8.migadu.com with LMTPS id mHneN38M8GVDhwAAe85BDQ:P1 (envelope-from ) for ; Tue, 12 Mar 2024 09:04:16 +0100 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2.migadu.com with LMTPS id mHneN38M8GVDhwAAe85BDQ (envelope-from ) for ; Tue, 12 Mar 2024 09:04:16 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=JZfSvI8F; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=quarantine) header.from=icloud.com ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1710230655; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=tWss2KypBvC81qwRWDd9i4ecPxkQwy7HIDppO0qZqUg=; b=PVhtedr1fe8N1LGp5I50KFmvT3/GLz4nfgBDbX2UCSUEeNl4CGKXt0JuojkoDcLh89tHBh 3QDmIS/EvI0VOpwdlsSDSAGaa6/IKJr8UzT+B/LbdNBQ9Q46ZaWhiaYlawji1Lt+UAghhN AlLmLemdSmSp4q2wShtoPQDA6ymJcTA4Tgv7mMJ0nrJZw9uf/o2JneOe7uy5ZBqGAvUY5T 5JaBzlVWeKv0mMsprgu/9Kl1wSYxwnar9tpyUWR7FNuve4KaCzWpJZXnfFlgrG7Gp3qMdq NFBq7V4uLg11GClQNMs7dCq5p2HOuV1ciXKcmjOle+3eoOWQyadf2ImRcvYFoA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=JZfSvI8F; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org"; dmarc=pass (policy=quarantine) header.from=icloud.com ARC-Seal: i=1; s=key1; d=yhetil.org; t=1710230655; a=rsa-sha256; cv=none; b=Nb2h69Zuh4KlbUu24Mb81zogS9WCaFMLIGWZcq207DB2IdiNjZBWAdzahZz0xN1jCfdN2Z XMXnKY7k4/KAsYhjH0A89Qlzmq8V+Io+gkFm6tBSLgzquMQzole1ihGcDfNVmf/c1wm4dR mLB9HCdr9apDb2siqgC5JkfRXwexlx3mkK8fAbzKpPlMgpUJ68KFhdJRTu5V7x1N55DfIH 6gimj7wm7sN+4dAnPefD+jHRiBeQ+DLxhA5Ai879vrq027kpZkijiJsOyJs8g0qw2KVVNx RiG1n75t4tGw+/LSQ82xf99D+kMZmXVoV2Cy6Elpafv+r9jKaJdYcpqQbTYGvA== Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id CF88C1470F for ; Tue, 12 Mar 2024 09:04:15 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rjx6g-0008H7-M5; Tue, 12 Mar 2024 04:03:30 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rje4L-0001Sr-St for emacs-orgmode@gnu.org; Mon, 11 Mar 2024 07:43:49 -0400 Received: from pv50p00im-hyfv10021501.me.com ([17.58.6.48]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rje4I-0001Gl-BG for emacs-orgmode@gnu.org; Mon, 11 Mar 2024 07:43:49 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=1a1hai; t=1710157417; bh=tWss2KypBvC81qwRWDd9i4ecPxkQwy7HIDppO0qZqUg=; h=From:Content-Type:Mime-Version:Subject:Date:To:Message-Id; b=JZfSvI8Fl5cyrSwDwiUJP3cx8r4BPjH7AvjeFsfDJH5B+cHz80umIA9rSHN4zXQxv ClGEbQsPkhiVJVnwqi6LFk3JeKzLPhQoSAgFZezv3KanKiqOzKCF1uZ3LulOJNXyai i+7m5IEi5syd+wkqhzHZHmcYm/PG5zROYJxdTMV1PpDdNN2Ns0CA7VJmlndnAVsN+t ltAV8DPpayZKSD0Fb8Xdf/Y8sE+hgvJMVRzYUoqy5Mm00hJpDSw3Co78fL6MKj898u XXIjWwtpybP7j4kS82ELfTn7AEnA87vH4al7C5ImV1DSPxny2408A8VDSupC6kI4da qAYFvgOeKjRHQ== Received: from [192.168.0.104] (pv50p00im-dlb-asmtp-mailmevip.me.com [17.56.9.10]) by pv50p00im-hyfv10021501.me.com (Postfix) with ESMTPSA id A566E2C023B for ; Mon, 11 Mar 2024 11:43:35 +0000 (UTC) From: Wu Ming Content-Type: multipart/alternative; boundary="Apple-Mail=_F3DB98E4-9D72-4373-AF7D-C42376545C98" Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\)) Subject: Re: Table column formula with remote reference Date: Mon, 11 Mar 2024 19:43:30 +0800 References: <1F92C461-F43D-48F4-B153-1AD7B308D377@icloud.com> To: emacs-orgmode@gnu.org In-Reply-To: <1F92C461-F43D-48F4-B153-1AD7B308D377@icloud.com> Message-Id: X-Mailer: Apple Mail (2.3445.9.7) X-Proofpoint-GUID: m3tTDtex7ObR8rFvZY3dVy8Zuhgcc6I- X-Proofpoint-ORIG-GUID: m3tTDtex7ObR8rFvZY3dVy8Zuhgcc6I- X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.272,Aquarius:18.0.1011,Hydra:6.0.619,FMLib:17.11.176.26 definitions=2024-03-11_08,2024-03-06_01,2023-05-22_02 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlxscore=0 clxscore=1015 spamscore=0 bulkscore=0 malwarescore=0 adultscore=0 phishscore=0 suspectscore=0 mlxlogscore=899 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2308100000 definitions=main-2403110088 Received-SPF: pass client-ip=17.58.6.48; envelope-from=wu.ming2@icloud.com; helo=pv50p00im-hyfv10021501.me.com X-Spam_score_int: -25 X-Spam_score: -2.6 X-Spam_bar: -- X-Spam_report: (-2.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Tue, 12 Mar 2024 04:03:26 -0400 X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: emacs-orgmode-bounces+larch=yhetil.org@gnu.org X-Migadu-Flow: FLOW_IN X-Migadu-Country: US X-Migadu-Spam-Score: -6.62 X-Spam-Score: -6.62 X-Migadu-Queue-Id: CF88C1470F X-Migadu-Scanner: mx13.migadu.com X-TUID: 3F9PQOkwQZLE --Apple-Mail=_F3DB98E4-9D72-4373-AF7D-C42376545C98 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Problem solved with $1 =3D 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 wrote: >=20 > Hello, >=20 > #+NAME: A > Table with header row here >=20 > #+NAME: B > Table with header row here > #+TBLFML: $1 =3D remote(A,$1) >=20 > Does nothing.=20 >=20 > $1 =3D 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.=20 >=20 > Same result as above with @0$1 instead.=20 >=20 > $1 =3D remote(A,@2$1) does what expected. For every row copies the = same value of @2$1 from table A to table B.=20 >=20 > Need to refer multiple columns on different tables in a column formula = for a final table.=20 >=20 > Please advise. Thanks.=20 >=20 >=20 --Apple-Mail=_F3DB98E4-9D72-4373-AF7D-C42376545C98 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Problem solved with

$1 =3D 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 =3D= remote(A,$1)

Does nothing.

$1 =3D 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 =3D 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.



= --Apple-Mail=_F3DB98E4-9D72-4373-AF7D-C42376545C98--