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 GDdFIBJQ8mVzfQAAe85BDQ:P1 (envelope-from ) for ; Thu, 14 Mar 2024 02:17:06 +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 GDdFIBJQ8mVzfQAAe85BDQ (envelope-from ) for ; Thu, 14 Mar 2024 02:17:06 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=lAfBXxhM; 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=1710379026; 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=37LSyb5dxsTZWuiyOIEjy8uQIaDs4HvB0JqG1qCW9l4=; b=KHaa21TcS1g8mBLbXKjXDfahlXY+sXe4uMG4amdt82QlzjxVGZJyOEsEoy4/kL0Fd9mOCa +X1gecx3hbT7fQ3VuvBmhhQBWpJd6iZl/ZFgZbiSVj5yqoTufvH3vowID1GRQ9wCC15TZP 33eSurn4inHuk/Mx3+gzpIxdH6z3KfRunga9MgWnC+0JU+gRqohmUqWW0pa23OgAK0UBIB 6+JCO6tjZ8BZ74KLLGtSArb/ts2ioFRzj0JyBy5m85AqJVV6l3Lco65PTjJSH/ten6UDkM D5cBWfVlzLn7Hro2zYCoENY7DWdfOwAUXq6q5avAt4wvVnCy9TRK17Kzsz5ieQ== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=icloud.com header.s=1a1hai header.b=lAfBXxhM; 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=1710379026; a=rsa-sha256; cv=none; b=pk0Pqx9fdKzJ3eBk5PPRZJEQO91dWTcS3s5NHWgEflgszRgEG70PuL1q3eQfWL8Dpu2MFd XGV8sYD2AEkWKwBbTzb62Sxmq+sU5U03UDXgVUCS/FvF2+BP7E/D5MvenfY9IE9WQqH/zD k6gGl/tH+eY2YPM+274XQxgul5eb74XuxwK/5pZd6arOA4CLDN3sLwwWKEgio5YZrADoSl ZEkEcjMMFen9GFxtUoU19nerx9XtWj7MVZFDXQdZBeuiu3hxcktaVkzX+oR6t6MsqMZlom RTZEpqcQGwhiTLd61Z5hNbidNyqT3eH6fMlDFMlJ1KncC4zC71yC4inInJ8n+g== 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 287E93E0EE for ; Thu, 14 Mar 2024 02:17:06 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rkZho-00056d-AI; Wed, 13 Mar 2024 21:16:24 -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 1rkZhm-00056R-Dz for emacs-orgmode@gnu.org; Wed, 13 Mar 2024 21:16:22 -0400 Received: from pv50p00im-tydg10021701.me.com ([17.58.6.54]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rkZhk-0001d7-Tl for emacs-orgmode@gnu.org; Wed, 13 Mar 2024 21:16:22 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=1a1hai; t=1710378979; bh=37LSyb5dxsTZWuiyOIEjy8uQIaDs4HvB0JqG1qCW9l4=; h=From:Content-Type:Mime-Version:Subject:Date:To:Message-Id; b=lAfBXxhMmumknBk3zKmccktsyE6SiP5EUf2SgaykGtaq7xCxVPeJvjHyaMhQpyo9P f0TVzkkWrxTB3fBn13pnYLYXBxYSBOyo/aW8P4E1gx9MBIdY3VTLBl4p+6qxJWrvsf DE2uP5txTHXSyp+TFF6oYavazA0dQh+G/s7So0OUAJKeA0VQW+sQFl46Ha1PVSZBYw 5wNgbX4HgAgQyyYgZGusci8KRN7ZVWRrSbPb5gFxQKc+JLJ1B0m02j4jv7gbMCCNFH /xvMZKMC3m22iuh1CilA/pjX+xpNqvRokiWUJaYaq24gZXsnKtfXJwieiIDKUSexOU emxNrsWnLUa1Q== Received: from [192.168.113.217] (pv50p00im-dlb-asmtp-mailmevip.me.com [17.56.9.10]) by pv50p00im-tydg10021701.me.com (Postfix) with ESMTPSA id A6E683A0CD3 for ; Thu, 14 Mar 2024 01:16:17 +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: Thu, 14 Mar 2024 09:16:11 +0800 References: <1F92C461-F43D-48F4-B153-1AD7B308D377@icloud.com> <87zfv3bj8d.fsf@localhost> <86F6BD74-10F6-4796-B1A5-23B4FB425336@icloud.com> <8734suxr7b.fsf@localhost> To: emacs-orgmode@gnu.org In-Reply-To: <8734suxr7b.fsf@localhost> Message-Id: <196ADD6A-7FD8-4002-8C30-BFCFE71070BB@icloud.com> X-Mailer: Apple Mail (2.3445.9.7) X-Proofpoint-ORIG-GUID: Cr9l6MnxAylGlbxwr675Ou6-OiT0dVJ2 X-Proofpoint-GUID: Cr9l6MnxAylGlbxwr675Ou6-OiT0dVJ2 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_11,2024-03-13_01,2023-05-22_02 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 adultscore=0 malwarescore=0 phishscore=0 clxscore=1015 spamscore=0 suspectscore=0 bulkscore=0 mlxlogscore=560 mlxscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.19.0-2308100000 definitions=main-2403140005 Received-SPF: pass client-ip=17.58.6.54; envelope-from=wu.ming2@icloud.com; helo=pv50p00im-tydg10021701.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: -9.84 X-Spam-Score: -9.84 X-Migadu-Queue-Id: 287E93E0EE X-Migadu-Scanner: mx13.migadu.com X-TUID: d6DLmDwgXCTg > On 13 Mar 2024, at 20:16, Ihor Radchenko wrote: >=20 > Wu Ming writes: >=20 >> 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 >>=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? >=20 > 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. >=20 > In contrast, @# and $# are special - they are replaced before > remote(...) is processed. >=20 > 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! >=20 I have some trouble at understanding your answer. Do you mean @# refers = a row on the table where the formula belongs and @0 refers a row on the = remote table? Was tempted to describe the former as =E2=80=9Ccurrent=E2=80= =9D but remote table is also current when accessed. A better noun may be = needed. Unrelated, but appeared on the same trial, noticed a cell was = mis-calculated. Could not pin-point the reason before error disappeared = after running a side formula performing the same operation. Formula was = simply copying column values from a remote table. Remote table values = were never changed. Recalculate all and C-c C-c were performed multiple = times before the curious fix. This made me worry about reliability of simple biz calculations I am = trying on Org spreadsheet for the first time. Please advise. Finally I moved columns but now column numbers in formulas don=E2=80=99t = relate to column order on display. How to understand which column = formula affect which column? Sorry to coalesce multiple questions in to one. They just came to me = while typing.=