From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id 6Pi5MqMs32DDUgEAgWs5BA (envelope-from ) for ; Fri, 02 Jul 2021 17:11:31 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id oM/GLaMs32BbDgAA1q6Kng (envelope-from ) for ; Fri, 02 Jul 2021 15:11:31 +0000 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 9B32D2496F for ; Fri, 2 Jul 2021 17:11:30 +0200 (CEST) Received: from localhost ([::1]:56102 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lzKpF-0004O0-A0 for larch@yhetil.org; Fri, 02 Jul 2021 11:11:29 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:36104) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lzKoD-0004N4-UZ for emacs-orgmode@gnu.org; Fri, 02 Jul 2021 11:10:26 -0400 Received: from mail-db8eur05on2119.outbound.protection.outlook.com ([40.107.20.119]:37035 helo=EUR05-DB8-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lzKo8-0000hi-HP for emacs-orgmode@gnu.org; Fri, 02 Jul 2021 11:10:25 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=LEhrmdK7XXbAzk1nIg3dflvOh6blF2+e89VXslHr04vZM1gvyygGuE8tWn9CTb/RQi/7qALSHTL+q+R+eB+H1gA8h8G3wkKr9DLBnvF/5V1iyQ7zlPp/+TrRI13RBydUDPUb10LCcu52yo1+V9p97TV6hCidfKgD96eMB0oD62W5N0E9X/sMjnu39MpX3DGQsu2M1Ocm7HpH0V6E8UrAUeYIFYMjt3zIT50m6J4aC52DGGZutPWbd5VEmikgU9JEwGPPMauMQG0bZjYtNNMYWEA38cEVBFX18l97jYt2Rwd+WfH7N69drdIGt3ew1RjPJYgZzad34sE/RqdFg2ppqg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=tyLX7jw7CjgoMIxEhiuV1N/ImiYDdUUonUI81edamOk=; b=WbXiZgS7gm/ncKok05wSi9X0Dfehyh8l9CFoqnUrvbsJynn6rKVcjQgLUlOpzsSqOS73jc4qtlsd9GEAgi8DOug4K700pxuRnoNxZHr2tQm92zoY2f50OyYKBltKLWHcZ0S0PCTdcqUYV9g4kSec4xmsQ6lkfIwzsFIi8DHLvxDkGjpusxSYWpdZbntevhWDbJuwzHLfkOKC/vKiugiIjmM0gh7xcLUIqfEkkiixhfT02wCeV0qhFjp6Wfn8iBcPLiCLiFlApNvnCZRr+w7X4LjLdgig7VVUiDQo7Ai+/WdLuzx4LfttUaD5cIwB5/bcZ/KF1K2+XkWHiQRLj2SLxQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucl.ac.uk; dmarc=pass action=none header.from=ucl.ac.uk; dkim=pass header.d=ucl.ac.uk; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucl.ac.uk; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=tyLX7jw7CjgoMIxEhiuV1N/ImiYDdUUonUI81edamOk=; b=R/nXTHJ4fFBRk+oGQPWOx3V6DQIYo0Qr8G4LPx9c4GIbyCFppeqmZZG3Lwcz/2ppjw+q51buD162YAIMbMvWMnXo4Z2ySlll7wbcmj0GN4LIHaVZbq2Xqbr8DJD7GS3BWLDNQ+jLpuE3jHTTgKCmkhiea/K1WMoolZ9DG9kDmoA= Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) by PR3PR01MB8052.eurprd01.prod.exchangelabs.com (2603:10a6:102:177::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4242.18; Fri, 2 Jul 2021 15:10:16 +0000 Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::49c5:c7a4:70:85f]) by PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::49c5:c7a4:70:85f%4]) with mapi id 15.20.4287.024; Fri, 2 Jul 2021 15:10:16 +0000 From: Eric S Fraga To: emacs-orgmode@gnu.org Subject: Re: how to add a range of columns Organization: On the Interweb somewhere References: <87lf6pgl89.fsf@mat.ucm.es> <87lf6pm672.fsf@ucl.ac.uk> <87eechgjbo.fsf@mat.ucm.es> <878s2pm4jj.fsf@ucl.ac.uk> <8735sxghg4.fsf@mat.ucm.es> <87y2apknlw.fsf@ucl.ac.uk> <87wnq8g672.fsf@mat.ucm.es> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Fri, 02 Jul 2021 16:10:15 +0100 Message-ID: <878s2oeoq0.fsf@disroot.org> Content-Type: text/plain X-Originating-IP: [2.29.174.230] X-ClientProxiedBy: LO4P123CA0356.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:18d::19) To PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from t3610 (2.29.174.230) by LO4P123CA0356.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:18d::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.21 via Frontend Transport; Fri, 2 Jul 2021 15:10:16 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 8ba721e4-3f96-4b7d-e73e-08d93d6b7fea X-MS-TrafficTypeDiagnostic: PR3PR01MB8052: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:3276; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: DEGADraP8uHkiKtYJ0qpNLh4QcH4b0Uj6D9ugA8IlKKbfAZWT81rCkbehLmFu4dVcUYdnHNVxyj8EU0DJS3S77D5h6JoLHWBNlsIWA3HIiHb1KIqAGFjr3nItzDLr99upRqiuO66t7GhBI1EOhDWO16X3S/7yOjDdy2ia9UZfKd0ePtcqOZVXIoQ6US4TsAwfY0+ggbESzKjcv3P1XRQ9R12RQpUze32xvMnophaaCMOb5ocjo1j2OFyCda33g+uxBdh3SxNzeTZZ5cM8GGsuJX+K4Ae4i/bUlkumHkgk/odZPWQaMg/bfSR666vdYDQT0MzzZKp/sNh9lMEmV1kS8gm+67ra+suQoKvO7VX4nnK4o6Z1z6wlCL/R16UgQ0V9nInTP2UWQ8RArN06NR0WHVXFfoPN0dBN43EZtvgZj9p4Iwxo1u/qEDUTihwx6j+OLYg9o9txSyX+cIj/zyWyT/SVRg3jOToUC7iBgX3WMSsprOSX4z5j0WSrFt22Wq9XlL6stPiySOgbGlm66juhQKu7Myys5JAWOL3E7a/k6LVKGLBDxygr0kvkV1COtqT3ZayKQssa8tMZgnOTD9ErI4wml+PsUxLAIIXNjAvwNks/hsjf+DWNjNQyfUuvhtIf+OeMO/kN2LXpqGvF1gC7vFE9f9bTi18Tc6HdX0Juk1niugVY7TIScSJCgEGGqxy/eIo1+2KX01sgGJTypfRUembzirrtCfJ0BRQ1EYcdgr9+Ho/yyVcJsXx8hd7g2Riu8lm4GcEUhRKlQ1bpAgAtBq8FoYaP7mhrKbz+Uqf2As5lOPkYrUAYVBvYf2QCZKO X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:PAXPR01MB8415.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(396003)(39860400002)(366004)(346002)(376002)(136003)(36756003)(956004)(8676002)(66556008)(186003)(36916002)(6496006)(83380400001)(86362001)(316002)(38350700002)(38100700002)(9686003)(6916009)(786003)(16526019)(66476007)(66946007)(52116002)(8936002)(478600001)(26005)(6486002)(966005)(5660300002)(2906002); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?dSfdmzSBTqS/B36UmSyfOhXImdjWoFBCCyj/Tfzm4aLVQ4L9PGzbw8cl1Irr?= =?us-ascii?Q?A0oegd+/lS92FONcawalpTM/NLono0tstokRf6qTg6o8maNV3bpcKcpRURvK?= =?us-ascii?Q?ZeFr4lTk5wE5+7PPkNEhj9EF1z5YMPoSc4f1i3pQAJ+RG4F5TJ7Yy/1fmJ4T?= =?us-ascii?Q?vIE1hb+Ks6zoi8Mp2sitkm6pLhAUR+yRNHq/S3RdUbR9lqGJ0tc8Rp0Xp4a4?= =?us-ascii?Q?ReOT8wORqqi2Q7blx2PQPMBDq53MLVXIrysLtt9LDyVcxHpQZxKkq5Sz+21s?= =?us-ascii?Q?FGi8llFGRszutSeI7vFVXYXJxwWn8T5XV2oMEeQpsdcO7QQClTixbLsL+XaS?= =?us-ascii?Q?o7p7DK0oCI4kdhlFYxPIWumPVlEtNdjrZefWOVWBCF9ueJLGEbfKmKsh+b4q?= =?us-ascii?Q?YtID4qvrhtNGml6/Vi6HucXzB77jgo3xAvQ6GomLAxBDX92maV7THyVc02GP?= =?us-ascii?Q?wLlVp+vCJvddvCe+F5pCUFSJio64AoM66Ax381onUWLe3gLl5Gwmi3hOj2Oo?= =?us-ascii?Q?3t3yM3lBL1AapoSTdY9OotGov2wAhPFRza4v5WD+GRYsxSKGDsgQqvC7o2l5?= =?us-ascii?Q?/rgKVPVrBffk1U6E+nGUD1ruwCeALVTSgUqs8iioYsxr75O5ECY82fdoGZhU?= =?us-ascii?Q?56HGPFDhhhc1P/xNtjFcErAkXtw5/xKe70KxZIyDwMbgaEkpGXsxTNX2PaU5?= =?us-ascii?Q?XksgsXi3wyY6v6r7big0eA+jxvds0At6qsQlDk2St/11PNMb1r9/ZqYlTgtm?= =?us-ascii?Q?bvk5Psz+pNRGY6VrTPLJtQTdTLoH+AfWOQZZ2+/IyRCwSgY1B0khK6nooCrO?= =?us-ascii?Q?uKbJSoCYBCcGzmPjE1MSsLyjA1lGDvxqgILQzS/i0CzGovamumZmfl0YUeuI?= =?us-ascii?Q?TNqakwikJAWwx6ld4r0nhBHOiAN6zBnbVtWK67hmLv69tQR56tTW0XZOKzBl?= =?us-ascii?Q?fRy+bF8J8+7kkSvRSOKTDToErIz+w3QVu/iy+JA8yI++yhZiCy+oBUXCBPEu?= =?us-ascii?Q?DFUL7c5ZOZrx5oFQnmX9K8EuuKwr0y3ddNayciF8dPaP9jY+O1PZP3xW2ZX5?= =?us-ascii?Q?eDLJz0mkAPuczn7OSo4agisaM6NTEb6XCFveOGHS5PYmmBbaRnuslFBGOWnO?= =?us-ascii?Q?OmhGKHT52CHCsupFTlPqxziL5kIuWtz1yWHmWirLrXe767QueobXvPJqbuTV?= =?us-ascii?Q?vbRp7S3hK4m2+KWJ3jQ7nh6tVSDySlYf36+h/IWoAM1FLcaKuwMsSDnY4asi?= =?us-ascii?Q?cJ8sLuCUmISJWa+h/07hb3fiL0DORZ6ui6RUio7LZwwzAhFrlzr0Zj/fndR+?= =?us-ascii?Q?9xaRSt04BOOs+XvH1c36XSUz?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: 8ba721e4-3f96-4b7d-e73e-08d93d6b7fea X-MS-Exchange-CrossTenant-AuthSource: PAXPR01MB8415.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Jul 2021 15:10:16.8194 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 1faf88fe-a998-4c5b-93c9-210a11d9a5c2 X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: so2BPpTozrsoSVsnPSHkyvkczoMh0Y6b5j6kfyiWwm5kOisSpQUVKMbn0j5FnrvsubwFp8mDvkrq/vprNbPbuw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3PR01MB8052 Received-SPF: pass client-ip=40.107.20.119; envelope-from=e.fraga@ucl.ac.uk; helo=EUR05-DB8-obe.outbound.protection.outlook.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 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" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1625238691; 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:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=tyLX7jw7CjgoMIxEhiuV1N/ImiYDdUUonUI81edamOk=; b=Usd35fAg9kgywAj4V3JN8hD+WvrbW2WUK46U+xEJP7Mrj/kj323EE1XluC3LAiQcR2r0M0 2YpSnJpCCm3FEJIao+FDs6IcwvzhIuYQxcgHzlc0Hx2qgyC1eyjnU3VYkuvamsTTz2PI3q vJsM+08Ee+2ze3KGHjOb/HDyKlevsO1e0PKgViNG6JMJlCBjLFRNwVToupbc41o1qb9F2H 1HgxUkpRJdseBHD9tBaBchWIDMdOELj+/OftTvohlsPMgpEjI8Gtc3UfRf5autoMy8zYme zXk+BmCF88HVvDjr8z7kZjNrGgFcY4H1iJi8EQkpYmnSeXa6vsFtwfiO/06Fyg== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1625238691; a=rsa-sha256; cv=pass; b=T/2CMgGmfJAimcmVCqyXGIgbgAEsmwyuFIkNQ8Z3XeAOy3MEJ9CpGkpkeBsF/ceFcNa0z/ zdrDgW6uCh0CP1M1hhf4RyJF6ru7r5SnbkIHrdyf3hYts3DSQ9EDz5fzQQlg2ehmn7piID 4rTLlB2P2eaE5m2lN2etd+5H5fhXa0bJu4Bq7bDqgF2ZIAFFwEmHUx0QHHDQZ3oWZpj5O4 VCI1R2AYtjwqeh5BZ5JT7xQVQP65CnDm5qeh3sCjzkSuNI670+uAfdR304RT7u6N3CWJh/ JmMV1tGkKyUrtpCdYzibBvWuo2TRY+hOMiR8Acr9Lcn32cQsBQY11It3VBMBJg== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b="R/nXTHJ4"; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -4.11 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b="R/nXTHJ4"; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: 9B32D2496F X-Spam-Score: -4.11 X-Migadu-Scanner: scn1.migadu.com X-TUID: hqN4vQ9VbaMm On Friday, 2 Jul 2021 at 16:07, Uwe Brauer wrote: > The problem is the target @<<$3..@>>$3 > > There seems no option to specify such a range. Sorry, I didn't explain myself properly. You can specify which rows should be calculated automatically so that you can then use a simple column formula without it extending to the full column: #+begin_src org ,#+Name: check | | User1 | User2 | Result | |---+-------+-------+--------| | # | 1 | 3 | 4 | | # | 4 | 8 | 12 | | # | 10 | 3 | 13 | |---+-------+-------+--------| | | 7 | 9 | | ,#+TBLFM: $4=$2+$3 #+end_src If you type "C-u C-c *" to re-calculate the table, the last entry in the 4th column is not updated even though the expression says that column 4 is the sum of columns 2 and 3. Once you start using some of these advanced features, you can make your formulas easier to read, e.g.: #+begin_src org ,#+Name: check2 | ! | User1 | User2 | Result | |---+-------+-------+--------| | # | 1 | 3 | 4 | | # | 4 | 8 | 12 | | # | 10 | 3 | 13 | |---+-------+-------+--------| | | 7 | 9 | | ,#+TBLFM: $4=$User1+$User2 #+end_src HTH, eric -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096