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 CDuHOk0S4GDxawEAgWs5BA (envelope-from ) for ; Sat, 03 Jul 2021 09:31:25 +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 yIpONk0S4GAMSwAA1q6Kng (envelope-from ) for ; Sat, 03 Jul 2021 07:31:25 +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 E6100104AF for ; Sat, 3 Jul 2021 09:31:24 +0200 (CEST) Received: from localhost ([::1]:45094 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lza7X-0005aR-1x for larch@yhetil.org; Sat, 03 Jul 2021 03:31:23 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:54434) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lza6p-0005a2-Tp for emacs-orgmode@gnu.org; Sat, 03 Jul 2021 03:30:40 -0400 Received: from mail-eopbgr00139.outbound.protection.outlook.com ([40.107.0.139]:61826 helo=EUR02-AM5-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 1lza6l-0007p7-Rj for emacs-orgmode@gnu.org; Sat, 03 Jul 2021 03:30:39 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=if2zJ8rG2i8TOtlW/0VdrUdb4QV6uYzQE6sSiEuqEeT0N0seknaSW+aR7Q9loN0lgK61L4UPS3T9LQ+tx3fPcv8dVDDnB7SlkvSMJ3UgPniI1AZZIX7q9dVcUldw3SJN4DPtE7AQBWPhN2brERO62MvF49Af4oNFjDCwiIG2PEA1XWsBeXmGrp/dkk/iDuLfeGyJYL7rpG1Rp9mMd1zJdlcNVFG8WlQjaI/2dxjpQZo0v79wQYeM6qoJuisx600OVu+A0L3Bn9V2OOoFGOhx2lR4qI2YuWXK3q6F4Oekse+H1YkTjTvp9zyzw1akZvlCi/Dfnaa4UAFDiUbVVveMgA== 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=LBWkyMeUoUt1za/xXYrwshvFeR+nsWBPEWzutZsr0NU=; b=k+B6n7nbQVj5B1M4GQ3wke9+MMoi2m1+ECv4IsLymk43himd+rmQoCsOc21oIa48uKuDBFby7thMhZksxOvIE2NUWtgx/VqEuXwNLh3ZNVV3vHu+EYc81RBDVi5zGLp+w0zcyjxu6vZ/bSPczx2YfNpOSE1rJf0zx3KVHPOMI0AwPfLB8B1RsuHqtrlij7Z631yUpfmAQP0rpdxJTudDaxynGnrrj4ZhBFFrd55lRFyoAfLyrItsGbLhCdzcJT3z7udL0gqF+Yshhst7f+R+cJm1MHdCefIzi4D8qBxrCPqv2VQ4Ski4m7jAqQoqCks+AHM7fwFYFFAmyp0TpKBYJA== 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=LBWkyMeUoUt1za/xXYrwshvFeR+nsWBPEWzutZsr0NU=; b=J4llUcBwwPobvcvYbJTCyNeI1ERAGNwfQ3c+nk1Kfzj3HFTdGLREwzIBNowxwJiVPHN6MFxLyXIpvcjGq8DndFRPcBmNhioaNZC3p+zmNQu3ihKSmrMVQ0wT6PlZkaJTqfeS1WHiXDuq9a4q49rrGdkx005PzC6u6zKSi4pGukc= Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) by PAXPR01MB8381.eurprd01.prod.exchangelabs.com (2603:10a6:102:219::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.23; Sat, 3 Jul 2021 07:29:59 +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.031; Sat, 3 Jul 2021 07:29:59 +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> <878s2oeoq0.fsf@disroot.org> <87r1ggfst5.fsf@mat.ucm.es> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Sat, 03 Jul 2021 08:29:58 +0100 In-Reply-To: <87r1ggfst5.fsf@mat.ucm.es> (Uwe Brauer's message of "Fri, 02 Jul 2021 20:56:38 +0200") Message-ID: <87zgv3dfd5.fsf@ucl.ac.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Content-Type: text/plain X-Originating-IP: [2.29.174.230] X-ClientProxiedBy: LO4P123CA0151.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:188::12) 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 LO4P123CA0151.GBRP123.PROD.OUTLOOK.COM (2603:10a6:600:188::12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.22 via Frontend Transport; Sat, 3 Jul 2021 07:29:59 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 37154ba3-a5e6-4ef2-d844-08d93df45d49 X-MS-TrafficTypeDiagnostic: PAXPR01MB8381: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:7219; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: lNS4w88mtuhZpX/BuxgCqxmUgW3FqbEqlaGhL9XaganTlyrug7IPAKg9eXPUBD7WspcvJW5Cw8um5sskj5amxUuGj3LELFLCtcBkonKBEipoHbVMETrChR52/K2hSEMrCVjsYgemsZT7WvvO2cNJZaNpjPezjjhzDazfB6o9GdTN/fK2pvzydkqbfmZAtL8kEoiA8qjZnjLNJvGORRPIAOYcKMJdk1Y2uViUVkc1XfkSKlBdZTONQ0aLqIE4UYsbv7UYPvJYWQsiCaHRj4jz5BHO4NFDZN6/1Cg6jni+pSSZvvvWNgJfNDtRZkHUyoC1W15xr1Qx7JGjKzfH42GHnc72emYX0pjGRyNnkzlD79Gh8TdLfF9F5OkMGgM/mKkPK7ZYq3yGErWtHruwIS2aV6a5nGlby0xnm8zSAoVgfBWHXlxhLjxEVXbA97NDh0w+4WkgsyLUOk60Pi6b7uYk9J0FSqAB0+I+pcotqJNyFyJj6BnmBsC6KpkqcDUSOCjbM+WgaJvQ6EKEZGrkLjLO8Z3hwiZPrj4l6xRy0U3qKczih4l+Gk8+csR69iWTbJGblQ+cqsPxQ52rjNTiybZfMQWIEkougsjHFsiWEZJ/FzFlqp96OF2BW2WSJUEPVvatbdHWeuroBXYATDxiJi03x0Vpu7yvsVSVGC5UTvFMM/6m2QtGupa1N4YHh57JkfcYj7fWAXPQh8fEUseUzHqzuDI6/hfku5VZSa/90y+qCuhiavLNJx40hnFXcalDWulpqrT16UMiUfs7E3o1EEz5Z/iS3FNm0pcb8Uue+XZQxn4= 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)(39860400002)(136003)(396003)(346002)(376002)(366004)(966005)(478600001)(5660300002)(186003)(8936002)(2616005)(4744005)(6496006)(86362001)(2906002)(956004)(16526019)(36916002)(6486002)(52116002)(8676002)(6916009)(26005)(66946007)(38100700002)(66476007)(66556008)(316002)(786003)(36756003)(38350700002); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?XWwSWxoDaVg/bnDLkuMSvZBwz4pKa8GjloZdgRuBgkTovas20UbO7dK407WX?= =?us-ascii?Q?wWnPg9L1yM0vLhr1D9YyCTMWV6uNeNerZdL6KhMOrijOZIWBd/5Ev07qW9QK?= =?us-ascii?Q?vKjZB4DM3qFDGWx8hPNw9goZv8a0f6MkX05TpKi1grkUIPNVytXhv+Dhk8sv?= =?us-ascii?Q?DOySw2IlGPMvbqlA75jDkoUlXcv2x2mt+pg2PqQKBcn5AwMBarxzO1/ORMS5?= =?us-ascii?Q?xBaeI1TiuZk5smQtcU+X54N+f2T8eJoWkP/IpeCZxQmnX4Uir9/KlAoZ8/UY?= =?us-ascii?Q?v/b+lKl5VRhmzuC62/YyYR3aXDfSs2CabJMySpmJuvhSqLTkDg46z2YxIxy1?= =?us-ascii?Q?2+rFxyb20xBGBBdPVOhArWDN9rRo3BJel3AeCto0eW4RNItV66Ms6oc4VsFA?= =?us-ascii?Q?ZBFBUT+aRBzIOI6yxNRbeDZ+XgvUW3WsZR73SHqHbmny7GIXYChZGB20NPvi?= =?us-ascii?Q?7mR2oNolaQMJ+X5IbWHNDIhvwoQE0IEV+JwVLMgpqyFp+uU1x+b6LLg9vqJW?= =?us-ascii?Q?Ro8celTPxlXrJtuNHCzMqFgyZeQMjUfT76gg5TZaEyX6IQIBd7WiPc3dqrC2?= =?us-ascii?Q?e0Ja9JPKUu8oVVr+7bkzL/Oi2LYyH3pExk5d5Vvs0VtmSN5d8eONfsME0W6v?= =?us-ascii?Q?eZ3HUsrjJyw9epsIPkCztZxz76flqEpJW9ebRlklskqVw9Viol325jWgy+Y5?= =?us-ascii?Q?4xWlv4Ri8GN30sPK7DFpFVSuCtD6clFge4AavRjC7okysQVNnFWLhRJGzCko?= =?us-ascii?Q?Ag45ZX8NWTPHsTmkLTZLaU+4uC8d+V6nZs9lS9OdC+PulnQWpJBbp7PdKU3z?= =?us-ascii?Q?uDGZ6wuxbafdiRS2QPhoKduviBgGzoI5iQ9QyZXC+Djd7FgtGLeODJDpVsPx?= =?us-ascii?Q?vkjoeeKdM38T7udUK4gWEUz6q3EkhkWvum4YxfMhHlu1HO1FDhXCVYmeq+n9?= =?us-ascii?Q?he/Mp7/P+L1qiXIVN/jSqnV0vga0RL3Qg8JhwSBY3RtM3YfLy2bVymrf+nCp?= =?us-ascii?Q?csXNiaRWn2Q3J4q6ClG7AQLkGnb6f+tXQkmwMfY7ZjT8TVQEYw0D/R1eF6wl?= =?us-ascii?Q?oiXnbdkd/l4ESR4Aw0LgPaHv8v+XnH6cdmv/o83l7LSbjWh+Ljb5SSSZICdq?= =?us-ascii?Q?BhcoL/hUGdmdI/DZVdl4qGjf4YWui5pNHBATnWS3cQVi4sz+gci2xxOQ0/Z2?= =?us-ascii?Q?2M3PtkognnhlHhVL7anjPxf4t+G4iyhh33jF6osVbxClivih2Cjgl8b2xLCC?= =?us-ascii?Q?0r0874+rPiMxwFHk19uctqMy5KvT7DqwaMvT/+27oXgGwjk/2uD46kyZJiaF?= =?us-ascii?Q?jj6d9M6wSYNxOtT6SQwunaEg?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: 37154ba3-a5e6-4ef2-d844-08d93df45d49 X-MS-Exchange-CrossTenant-AuthSource: PAXPR01MB8415.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 03 Jul 2021 07:29:59.7176 (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: B952xae5ajCBRPh5Ff0c6vnAdw49Qlq60XHmPG22H7G49tB0odgRXESTpYzY7mbuvgYWxoitdLxNTJVcCQM9fw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PAXPR01MB8381 Received-SPF: pass client-ip=40.107.0.139; envelope-from=e.fraga@ucl.ac.uk; helo=EUR02-AM5-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 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_NONE=-0.0001, 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=1625297485; 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:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=LBWkyMeUoUt1za/xXYrwshvFeR+nsWBPEWzutZsr0NU=; b=TRCKydbG3vJd0JbCyUiPuJIacFj2oVp738RH7JtaVyOk7mo/QSZFutciTJqzDsUxLXB3tR lic5c4ssTXlLRp4taZfyLvr5eDkemamsUUmXJKbUBxXA0Zj5OsjIWwPyso7fiTrKXvp3Y9 SiQuCabbrZVlN2sRRM4bN/yxbbUObSTvo62O2wQyNFB0fch9bivHruIRdLvxAdltx4Ic61 UXj3PCYdYd5uThg+v8m5riLGNFNVnmLI9/Qo2m2f/SrcPuU0MIPuZH0lxcgKmDGmPKGePV H7hj1DoI7IOYANwe8dHlFaH9MksH9w2of7VHnVfxM2HTkSadyMlO/BjNvzuDjw== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1625297485; a=rsa-sha256; cv=pass; b=bmbSZ2XOhs7W5FXmz9UUPc8RB80zs4WRJGw2vL7N1EHsiS9Ca5WBXhVNS1WleQ4GMZTS3Y +go7vapO1gmYenj22SSrdKC5VSnSpBpRmduDUb0KrYB3bHVN2o1JnW6isR8a+ued6X6Gq/ uz7YsUHXjqErGYAzyHecp727UNkZMhVCoBgeDO7tOH/KeLwckPwG0DDb3cuN4G6XMeQYB3 NRWuyzwIOziyvHa4hDALn2O0GLsgHyWBVxkLLYYl1DGN3X/Ra0/T8R6N5X7bpxItZBFmKZ 0yqhl4ktvELnudxeG9ZuPuDlPssaGbvG1NA3i8ykEq0KB3PqW7qNoiBUkf6Log== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=J4llUcBw; 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=J4llUcBw; 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: E6100104AF X-Spam-Score: -4.11 X-Migadu-Scanner: scn0.migadu.com X-TUID: IpfmDRmVxcnH On Friday, 2 Jul 2021 at 20:56, Uwe Brauer wrote: > Now I want to add also result and new, but only the first two rows, the > only way to do it seems to be your original approach. At this point, you need to start using more advanced formulas, e.g. involving conditionals, maybe. You could do arithmetic on the column and row indices ($# and @# respectively) and apply a specific formula if the right conditions are met. -- : 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