From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1.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 4Mu3LYD49mWE/gAA62LTzQ:P1 (envelope-from ) for ; Sun, 17 Mar 2024 15:04:48 +0100 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1.migadu.com with LMTPS id 4Mu3LYD49mWE/gAA62LTzQ (envelope-from ) for ; Sun, 17 Mar 2024 15:04:48 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=posteo.net header.s=2017 header.b=kTn0ZqNk; 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=none) header.from=posteo.net ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1710684288; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc: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=H3zpL6HQFsVHS0uPXrc8vjyifWhVd2QknoTnxTwfQRY=; b=K+uMZFCuYBA859KXTyFP1efmu8b4NKVP6S+7+EXvEs/URrG5TaP2HassbLIh33qCOtT3PX nODBdo1bylA3fXr5D1f1QrN3v+J2M/bEEj5SiX1yXnhL8NF3L+XD6UOsPXNUAVeziKyGkZ T8D5ri9sOolnnMFOPHgzG70N7LJi774stJ4DYd1poR5rwTUfc36l43fsgxu6TbyT6wuEs3 Y6w4YFWyjdDH1hlSkzpbvPI5vERAGqe7LAKCmK8re/akA21Nxz7WCifUMViWbO9C+0wXRB j43rXMT47yCbsPIhZwyeB/JlWJn2cBNH/VX55QM0p9kLaKNmtGqG+qSBpk32mw== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=posteo.net header.s=2017 header.b=kTn0ZqNk; 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=none) header.from=posteo.net ARC-Seal: i=1; s=key1; d=yhetil.org; t=1710684288; a=rsa-sha256; cv=none; b=l+Wj5LLx4HSnM6aL4G/4e/XAJDy+2BoKxYTOv+0w0DjbHYcnO/AiyeN+h1Gnj6zZoNfqLH uS3+fACHOXJWMWfWTF9MMrG9nAfku9sD9X++ArOl4OCJx8efC+Er0SzcS0khk0DCiE3q+F 2wT9M7XmFMgFAKsWW+m3JOUi+cV+yxWV/vuynJliAfu2calHtFoEDXxzpZ1vFlFC/rqx0x UHiU0Tq9gM+koZuaDnbR4J2HGg5io/3+34wYq13SKVi8DE9lFDwU0BBqYRZQm5Vt5PWW6Q OdVtanERYq8yd8XxorHafh+Eq6mRwaOXeX829cfL5R28ECfkRbqeVYIWSRWu+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 6F35157BAA for ; Sun, 17 Mar 2024 15:04:48 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rlr7J-0000Nr-Ku; Sun, 17 Mar 2024 10:04:01 -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 1rlr7H-0000Ni-KY for emacs-orgmode@gnu.org; Sun, 17 Mar 2024 10:03:59 -0400 Received: from mout02.posteo.de ([185.67.36.66]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1rlr7F-00045c-1h for emacs-orgmode@gnu.org; Sun, 17 Mar 2024 10:03:58 -0400 Received: from submission (posteo.de [185.67.36.169]) by mout02.posteo.de (Postfix) with ESMTPS id 73EE2240101 for ; Sun, 17 Mar 2024 15:03:54 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=posteo.net; s=2017; t=1710684234; bh=LxstB+S3hl8NssmSX2YRPJ+eo4JSUEfM6A3pfMZPl40=; h=From:To:Cc:Subject:Date:Message-ID:MIME-Version:Content-Type: Content-Transfer-Encoding:From; b=kTn0ZqNkCu8082HNUaKDkeFE3VKJb0j/0BVCQD5mHaKiHbvZOiiUFzuPHqYenVkY4 smbgPiXkSdfVZ8oM5aS4Qxy609RzthWzD/JqVOEGjq3Q/MuohgUuH13Y/oKe3bsi04 0U9lLXoJKDKXb1hMjbFzpTBigxW6O48KgxOatSdsZetpY5jaNLZZBd4F0w/8T7bdyc TozRmFZL5B+BPniPw0KbHoIolx3ziE7r5cjL360kUa3UOv1QY6Gwn/m9xEbjXCabic vbbujbMSAghwx3yWuj7Wjz0qN7ooPxN2HuAQHHGhXwaDyrGEN8HU0aWArN2XEbAuJi 9L41g44m+8+5A== Received: from customer (localhost [127.0.0.1]) by submission (posteo.de) with ESMTPSA id 4TyKTj4jfrz6tvh; Sun, 17 Mar 2024 15:03:53 +0100 (CET) From: Ihor Radchenko To: Wu Ming Cc: emacs-orgmode@gnu.org Subject: Re: Table column formula with remote reference In-Reply-To: <0E2BEC9E-15B2-4FCB-9890-6BAD6B8B7546@icloud.com> References: <87sf0sh3w7.fsf@localhost> <0E2BEC9E-15B2-4FCB-9890-6BAD6B8B7546@icloud.com> Date: Sun, 17 Mar 2024 14:03:52 +0000 Message-ID: <87bk7dymyf.fsf@localhost> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=185.67.36.66; envelope-from=yantar92@posteo.net; helo=mout02.posteo.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 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, RCVD_IN_DNSWL_MED=-2.3, RCVD_IN_MSPIKE_H4=-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-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.49 X-Spam-Score: -9.49 X-Migadu-Queue-Id: 6F35157BAA X-Migadu-Scanner: mx13.migadu.com X-TUID: mBjOY+xb1LWT 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=E2=80=99t want to abuse your time. I can figure it out when neede= d. > But if you feel inclined to unravel this little detail of the manual > as well I would clearly appreciate the effort. The main difference is that @# always refer to the original table, while $0 may refer to other tables as well. (Generally, reference expansion process is not well documented, unfortunately; it would be nice if somebody wrote a documentation explaining the process - things can get tricky in some edge cases) >> Normally, if you use org-table-* commands, the formulas get updated when >> you move the columns. > > One side effect of using remote formulas is re-organizing columns doesn= =E2=80=99t update them automatically. I should find the balance of readabil= ity and formulas maintenance cost. But you may have suggested the solution = below already with named columns. In theory, we might try to update such remote references at least in current buffer. Contributions welcome. >> To make things more readable, you can also assign names to columns: >>=20 >> | ! | | P1 | P2 | P3 | Tot | | >> | | Maximum | 10 | 15 | 25 | 50 | 10.0 | >>=20 >> Then, you can write $P1 =3D ... instead of $3 =3D ... >> See "3.5.10 Advanced features" section of the manual. > > Clever. And we are at the =E2=80=9CAdvanced=E2=80=9C features already. Ar= e advanced-advanced in the realm of Calc?=20 > Asking because was also wondering how to optimize parameters (=E2=80=9Cso= lver=E2=80=9D) and deal with locales (=E2=80=9C,=E2=80=9D vs =E2=80=9C.=E2= =80=9D separators). For the latter I could possibly =E2=80=98tr=E2=80=99 th= em before sharing the output. But will possibly mess the alignment. Happene= d while trialling groff=E2=80=99s tbl. AFAIK, GNU calc does not support comma as decimal point as _input_. For output, I am not sure. --=20 Ihor Radchenko // yantar92, Org mode contributor, Learn more about Org mode at . Support Org development at , or support my work at