From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2.migadu.com ([2001:41d0:403:58f0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms8.migadu.com with LMTPS id kNlvDXJD8WXlYwAAe85BDQ:P1 (envelope-from ) for ; Wed, 13 Mar 2024 07:10:58 +0100 Received: from aspmx1.migadu.com ([2001:41d0:403:58f0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2.migadu.com with LMTPS id kNlvDXJD8WXlYwAAe85BDQ (envelope-from ) for ; Wed, 13 Mar 2024 07:10:58 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=prPfVGfG; 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=1710310258; 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: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=H1EFWyTYaN6a9lbAjsSnPk0QehfCJPw95tmgqtkGBnA=; b=ffGYOYOPVuJTR0PjaYhHsKO7ta/07FMP1W9fjh1ImiCWQ46ThFf8AGIVhbXboe/9Mf/tyL wOf3lBOrnV/oAtImFbx3zbG40y3QFdmu4pcliuNshveVQg/xpfEWOPGZkzh8MqvGD3Dznw bndAIyBJBqh9XWj4qrCb+jUl4ytHrsNlkvQtPXQVG2p/VoHIMf6FD/BKSLFHKC027QbZ9T otV2hSCSGvC8DXEEqhZjWGcCDFOkNCgXXN8HVWsfqyOpNWHpAPMUjgpEcKb+aE7fE2Lj6m XGNoVA+6PC41BgthrdsZlpWYWKXKJPjzyh4KZjQZJxe4ie0Jf9ybd81sR6fahA== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1710310258; a=rsa-sha256; cv=none; b=CS19fjPKGxRTcxSMr5u6VkAsWRPm/g5131LB4vK32eZCNvizFJq4vOI+ZvSb941pqyGnxa Zc17ZfVBNfcZSE6YSZBc6b+K+p/EQtKmEqoCs5YPlpshjJhlqqth9kFFpkJfU6aYsGsguu RX+5IB6Kk7u2Ax5dxpexc+rd8TUxhu6C7ZE/1UW+YQPQXgYcCpr7iUCnjJ8OWxlpDKUgPT gJKGIPPOxHgqTDbtdxzezz8bXOWi9cPEPjVR0KEIuGdGyBgpBEcGapEVc+ul8q6lL54qFs FXf3OST5d3iylEeSAbHDY303oA65O4fCuGlhLwBOOqtzkJJPcPkpM1Rf9EE1Ug== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=prPfVGfG; 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 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 BB9265A861 for ; Wed, 13 Mar 2024 07:10:57 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rkHjF-0007CS-OO; Wed, 13 Mar 2024 02:04:41 -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 1rkHjE-0007CI-9I for emacs-orgmode@gnu.org; Wed, 13 Mar 2024 02:04:40 -0400 Received: from pv50p00im-zteg10011501.me.com ([17.58.6.42]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rkHjC-0007Zb-FH for emacs-orgmode@gnu.org; Wed, 13 Mar 2024 02:04:39 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=1a1hai; t=1710309871; bh=H1EFWyTYaN6a9lbAjsSnPk0QehfCJPw95tmgqtkGBnA=; h=From:Content-Type:Mime-Version:Subject:Date:To:Message-Id; b=prPfVGfG12G9DRsym+5rGUH9lI1mfQxBmEXVVcsIdFNDnsZu7/rbx6C41gquvWKeP O8W13RZ6okDm3nQCe6QnylSb3mklr/raqCmeX0H/HSMBT5n8vju9TpCXQxJUKLzv0F H4BI6Mq8MbB57EuOVLQtbYuepP9TuhuOQhSiVUYCmQASk4oufJzKDPDlrFdOccXRyD 4Dm6y9wUIYjImqyPrZf1VFvydzcWNn2IMalNxIj+ylPnNPwvjVbTHgQptE2R4kno/I Yw/Cthqx7/oA0I+1ROLiTYJuHRtijRn4QqjpC2nyIEqLAoicODQfIAhBbGbEjZkBHB 2K6tpw5n9o88Q== Received: from [10.20.1.91] (pv50p00im-dlb-asmtp-mailmevip.me.com [17.56.9.10]) by pv50p00im-zteg10011501.me.com (Postfix) with ESMTPSA id ACF954A02EC for ; Wed, 13 Mar 2024 06:04:30 +0000 (UTC) From: Wu Ming Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 11.5 \(3445.9.7\)) Subject: Re: Table column formula with remote reference Date: Wed, 13 Mar 2024 14:04:14 +0800 References: <1F92C461-F43D-48F4-B153-1AD7B308D377@icloud.com> <87zfv3bj8d.fsf@localhost> To: emacs-orgmode@gnu.org In-Reply-To: <87zfv3bj8d.fsf@localhost> Message-Id: <86F6BD74-10F6-4796-B1A5-23B4FB425336@icloud.com> X-Mailer: Apple Mail (2.3445.9.7) X-Proofpoint-ORIG-GUID: rDOdR_jXYxavEWxKj8Fkh7BMJYczl0-w X-Proofpoint-GUID: rDOdR_jXYxavEWxKj8Fkh7BMJYczl0-w 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-13_05,2024-03-12_01,2023-05-22_02 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 suspectscore=0 mlxlogscore=866 bulkscore=0 phishscore=0 adultscore=0 clxscore=1015 malwarescore=0 mlxscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2308100000 definitions=main-2403130045 Received-SPF: pass client-ip=17.58.6.42; envelope-from=wu.ming2@icloud.com; helo=pv50p00im-zteg10011501.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_H4=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-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: -8.04 X-Spam-Score: -8.04 X-Migadu-Queue-Id: BB9265A861 X-Migadu-Scanner: mx11.migadu.com X-TUID: bZcUSUksmEW2 > On 12 Mar 2024, at 22:46, Ihor Radchenko wrote: >=20 > Wu Ming writes: >=20 >> Problem solved with >>=20 >> $1 =3D remote(A,@@#$1) >>=20 >> as described on the manual page = https://orgmode.org/manual/References.html#Field-coordinates-in-formulas-1= = >>=20 >> Where is the coordinate @@# documented? >=20 > I am confused. Isn't it documented in the linked section of the = manual? >=20 >=20 > --=20 > Ihor Radchenko // yantar92, > Org mode contributor, > Learn more about Org mode at . > Support Org development at , > or support my work at My fault. Missed the line "One of the very first actions during = evaluation of Calc formulas and Lisp formulas is to substitute =E2=80=98@#= =E2=80=99 and =E2=80=98$#=E2=80=99 in the formula with the row or column = number of the field where the current result will go to.=E2=80=9C So = '@@#' becomes '@'.=20 Overlooked it also because I did read the other line "=E2=80=98@0=E2=80=99= and =E2=80=98$0=E2=80=99 refer to the current row and column, = respectively, i.e., to the row/column for the field being computed.=E2=80=9D= and did try '@0$1'. Why is this different from the above?