From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.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 ACeEHX4M8GUSXwEAqHPOHw:P1 (envelope-from ) for ; Tue, 12 Mar 2024 09:04:14 +0100 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id ACeEHX4M8GUSXwEAqHPOHw (envelope-from ) for ; Tue, 12 Mar 2024 09:04:14 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=eLR7tns+; 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=1710230654; 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: content-transfer-encoding:content-transfer-encoding:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=40SV+7/KnALeR650YgNiQ93bMTUZdDnaaV0oigLLfaE=; b=P3QDPVlEfwJQyty6n5FUIVgfbxYZVKIvUOyjAFz/JGXhoZomx0b1WiEPaUlAAy2G+H8HDD yJ1D8NonBJ/y5xKUufYqbxunS7t7fUeX/BtC7vxdfgqeBxo97sgpnhRr9CeSVLyrtRlumM qu8Dd4jn8MI1qzCruuuvHdFbjE71F+dBSgOYoJHxWZZOh+x1LwN8iKYV2Q+3t3BDPXQxm8 wVgBxsTQ+1QDqUfQp50mBaspXBJSVwacjotY8AUhWVif1lYGqSXCaug0hPntpiUVEATMTp 2uEp0VBJYVB8nbGKwJFadkq1KpaCQrWiYleWFYGqfhQY75eAzALU+jHH0jf2JQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=eLR7tns+; 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=1710230654; a=rsa-sha256; cv=none; b=OjzqNgQRZrXnN8bgJ3Hqh1NtIiJEdGgStc/Uj1SpY6uc64kYGb0uvGxF08y1cQFEFbkwd7 D3fdGp5rKN1HwV8LoHNXe0FeRUGduIhDvKpm3B0BrfbFae7IAkB6lzQWE6MBK8U9LABrWA Nk0pQa16lrqWrUUYZtUIrvgPlFDrDmIVXziroEuWr0fBylgbl+3KaZmSZdGrzyOe/pdj2o XqyqWLyxJT0ppn87c3CPNaS7OkoZWI5wynoV8j9CM8vyA8cxrkryw5HIYuGqFrAptcva7a R9hhRQinCX3SY9KqyPDpNRi6qxDA1NIbpC6sKZVSZeEVnyy5bTA74sJK/WWJkQ== 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 56A24145A7 for ; Tue, 12 Mar 2024 09:04:14 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rjx6m-0008P4-PT; Tue, 12 Mar 2024 04:03:36 -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 1rjdGj-0008Rq-SG for emacs-orgmode@gnu.org; Mon, 11 Mar 2024 06:52:33 -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 1rjdGi-0006SE-07 for emacs-orgmode@gnu.org; Mon, 11 Mar 2024 06:52:33 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=1a1hai; t=1710154347; bh=40SV+7/KnALeR650YgNiQ93bMTUZdDnaaV0oigLLfaE=; h=Content-Type:From:Mime-Version:Subject:Message-Id:Date:To; b=eLR7tns+RzR4XY3heSuTSlcti1qd1MV1h5V8i/3X0Vd+u64AW4WLRPMJWR2T9FUQw bCBiO+HPMfA5OitoZa6vKbpPoDooiCe2NAIgxGOI9MTMu2CGLLngWjtQ5MrX4llu/5 ezB4a0rWRJRd8FT07xAwViveugSC5H7tjuGq4FRWqmMitMr9BFVYb1WPMuLbf8znQV +Yi3NPHULjno3bPbFXJPEvB0gTbDimj83bVAAhwi05qBVH3OeLVS2ZuMdMG+VJzi7Z dUSuIpQYIRBQnl1ZC28Ki+PPKF8MzE+8cRXJm9fZ40sTulU4SOPdExUXNcw6Ok2dBA tacXYQVB+kUGw== Received: from smtpclient.apple (pv50p00im-dlb-asmtp-mailmevip.me.com [17.56.9.10]) by pv50p00im-hyfv10021501.me.com (Postfix) with ESMTPSA id B78472C02BC for ; Mon, 11 Mar 2024 10:52:25 +0000 (UTC) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable From: Wu Ming Mime-Version: 1.0 (1.0) Subject: Table column formula with remote reference Message-Id: <1F92C461-F43D-48F4-B153-1AD7B308D377@icloud.com> Date: Mon, 11 Mar 2024 18:52:21 +0800 To: emacs-orgmode@gnu.org X-Mailer: iPhone Mail (19H380) X-Proofpoint-ORIG-GUID: Gq-_D5XYDWwKO9tae2oqJbKna7RmCKoc X-Proofpoint-GUID: Gq-_D5XYDWwKO9tae2oqJbKna7RmCKoc 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 adultscore=0 clxscore=1011 malwarescore=0 spamscore=0 mlxscore=0 phishscore=0 suspectscore=0 mlxlogscore=457 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2308100000 definitions=main-2403110081 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, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, 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: -7.87 X-Spam-Score: -7.87 X-Migadu-Queue-Id: 56A24145A7 X-Migadu-Scanner: mx13.migadu.com X-TUID: I9soC2fnGA5x Hello, #+NAME: A Table with header row here #+NAME: B Table with header row here #+TBLFML: $1 =3D remote(A,$1) Does nothing.=20 $1 =3D remote(A,@0) referring current row w implicit column does not work. D= ebug shows on row 2 of current table it returns the value of row 1, the head= er, on table A.=20 Same result as above with @0$1 instead.=20 $1 =3D remote(A,@2$1) does what expected. For every row copies the same valu= e of @2$1 from table A to table B.=20 Need to refer multiple columns on different tables in a column formula for a= final table.=20 Please advise. Thanks.=20