From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id CHckNLHg3mDe0QAAgWs5BA (envelope-from ) for ; Fri, 02 Jul 2021 11:47:29 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id GK/RL7Hg3mAHVwAAbx9fmQ (envelope-from ) for ; Fri, 02 Jul 2021 09:47:29 +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 0F1BE1DFD5 for ; Fri, 2 Jul 2021 11:47:29 +0200 (CEST) Received: from localhost ([::1]:47430 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lzFle-0008Em-FI for larch@yhetil.org; Fri, 02 Jul 2021 05:47:26 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:45954) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lzFl7-0008EA-NO for emacs-orgmode@gnu.org; Fri, 02 Jul 2021 05:46:53 -0400 Received: from mail-eopbgr70110.outbound.protection.outlook.com ([40.107.7.110]:44536 helo=EUR04-HE1-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 1lzFl1-0002Ww-05 for emacs-orgmode@gnu.org; Fri, 02 Jul 2021 05:46:52 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=BUBtd30QoQRrSCVfktSzhL/iNsnxdPZ94FQhPRSUmUEjJS1hKMEq4zsDMLq1gzV3jQkjQ9g1VxF7wFbWUqU2rIpgD52VPoc79IcKlGBDL74hhR/AiWHuYdjH2Mbb3y/yf2ofIxAssJ50wmSAwssQjN0wREFlb9vFBPV+3/pJMY6XLu3t7QZ4AmvoWMej5NKHJt8K0xbAvI9PN+al0SHQRuF6l9JtsM1lDLm4Y6XQWm9SlkcjsI91oTUd22qTc7BrBtjfYY/09AXmYpApvxNC/n2MaJzPe/DMJj/ZD5ap6tc0E/odnRRbKLJ0RPUB6k4TviT+kCbz6Yzi7HqIJ4ODDg== 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=fVJceJjQYvH9RQGhS79EI9vdUiffqmXB7tfOWmnxtpM=; b=ensRQDnaD+e4C8oGQ5MGu0WpUA3dIs7aEvtrlkvU4VcGEff8Q1Go6kE/Bsy6Ge0zS2KiS6L+z7HWbIdX/8atxO0cSDVrYhfAQnfm+YnB0SIv5mhYPl3Zc8UcNDD8r/ejEldsABnomJd70E25g7FwTWMAV3BaurBUicDqBM3EoqV1CzGDvR7YsPiS7eDfUrGV4BaeCAW3BNcwXgOoerwVcaTJK3yU31PWVq5VPBmLhCRlxDFxGErdG+UeB0D6XTZwZ1HwxNzUlUwVq10YX1oiTfjfr0BOSKW3JD504mADWNivKC9dYekfOMMfbGp0wtO+fAC3YM2PJK1H0jrTpNrASA== 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=fVJceJjQYvH9RQGhS79EI9vdUiffqmXB7tfOWmnxtpM=; b=nydwGAqE4UAPwC5Pab2lnM9Bvy3jWqALE0tVeWhtKAHLBeWT3SgIllc1w6sQRQy6mJOWb0Fy2g86qG0BgqLEfYpg8VRf/mfD4JQC0kxXFfVBCvHM+cXy0G4I/1ZXP/VN0hLZN1CiGtliZrBJNsGh31hiD8Z0OQE+YQs3nnRnVJU= Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) by PR3PR01MB8113.eurprd01.prod.exchangelabs.com (2603:10a6:102:178::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.21; Fri, 2 Jul 2021 09:46:42 +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 09:46:42 +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> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Fri, 02 Jul 2021 10:46:40 +0100 In-Reply-To: <87eechgjbo.fsf@mat.ucm.es> (Uwe Brauer's message of "Fri, 02 Jul 2021 11:23:55 +0200") Message-ID: <878s2pm4jj.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: LO2P265CA0392.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:f::20) 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 LO2P265CA0392.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:f::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4287.23 via Frontend Transport; Fri, 2 Jul 2021 09:46:41 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 673ee67f-4c05-49ed-6d80-08d93d3e4bcc X-MS-TrafficTypeDiagnostic: PR3PR01MB8113: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:8882; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: n1U00CzyJQaBrkdVSJoFB95lyJBzcPJdnZqVT9d81fBoCVdwfj/YUOwTsU//ctK2sXKOAVvySKqSw8eyJ9VhAyHwCa7gqbIqWH6L4PsF6Hi5ITpOr0JPv6QxmIF5h2N1dNWHeRMfAeYuWo1/hQm4o7jUJXb7mHff993KdHTeRfXZ9KHfMjjQ6/DeH4GKUpHXKZyeYRtCpo09SgIbbAFMS68dA5vZkFYF6Db4/FOIn6wtjTG0JQnX2cIAngFfMNVt6cWvZfaPAjCuvqHYp293Kbw8Kw2kr7X35+n49qKk4ce6MG1BSwSHO6+LsLNIHB/FgvJnJUZJM1ZA8EEjA4kyqdzFqq5P6YykzV+iU1A1GKx3Gs2Zz9EjbEbhRyOrEALZVzPd1wmmEn249KbIl89SkS0u60vZJ8KaUkGDdoaDjk938N7lppTeYaKqfV0qqfvmN3EGv7IlcEld++zXQaMwrSF2J2wm3xU/z7V/FA+hKXDt60kqiUlS1Go1MF+wjvC0SvLKQxg39hDNSFO7/I3h1C3UnW1GTc5nItfNSUB4htXGmhpgBCgMLlG9QohY6IY5L78HPF6ib9xR/XXzXm2N5xSx6/Kl1mG8KOkfjGtfTW+lywIcrQI7b6qCBp1fzzDqPw42Cp5n1mSn7UYpY2lM6cTIc44pfaFl7CA2+L89dLVx/SsILgjs9lt42llid2enE+PyYoYIYGUIk6GCtPYHN9OVa0I5lImxRNkrptB2Ni0mBXAzeGnS5aDqijcxf6A7rJItlSyobWFxe25k1KneYFRQEVTlwTFs8PSl1vdx5E8DdGHa7jQEp7uIFlbQSNOWO0/DZjFO1Hr2D2g1ydgyrw== 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)(39850400004)(366004)(346002)(376002)(396003)(136003)(26005)(66946007)(66556008)(66476007)(8936002)(6486002)(956004)(2616005)(186003)(6496006)(16526019)(6916009)(52116002)(478600001)(36916002)(5660300002)(2906002)(8676002)(38100700002)(966005)(786003)(86362001)(36756003)(38350700002)(316002); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?WJnhrRFvarmf6xu/HmwNmmAoOTifYonDXimPpqHE//I2TXGyJMGXNkeTo9qS?= =?us-ascii?Q?FQsHxyfD/z3F+Lzo0G49f0P0rUzH0EgndCOk7ktHODRDoAbnV0N+edxU6hGs?= =?us-ascii?Q?8jOxF1njZFxF2qCl2CZQcpBgwDHin+5w6edMuPx7YEdNLsuxLRSG3DIQcuY0?= =?us-ascii?Q?ruSQohf/LauRz1UHnY6aTJ+OGWGl7+lEMVXmey7fa0n+GMwaaj3jFyPCkp3X?= =?us-ascii?Q?wLhU2SdeJknS2NA72MEJSBEaZRmJu71F3K4twt6USLT+nbD87P+zUEillzEh?= =?us-ascii?Q?m+WsXzIlxD8Z88puH2GngVo57fFsVcvV0K2tuH34s2V6WJ8HzR86yyFOW5w7?= =?us-ascii?Q?2ZdCitmHnwJ/kyThZkinCsfmGlU6xxPdWOT0Yl96t8PpjRKyxYOFoXcemvIq?= =?us-ascii?Q?/eIwUcnX4h+K93CxggYh6KdyP7Xyi99nU0cahFqsmPj2oIHmit+wWj9EKPWN?= =?us-ascii?Q?VsUWxQiLKKFKy/Zdn5POKJYztPZpSk3z40FKXMtUQzD5sgI7B5aF1rskOpxd?= =?us-ascii?Q?2tH4GDocUFo8Khmtv+dgmTm1HcpnUEkXPdF5Ym7yCrKbnbh1+ByM2uXYI1Js?= =?us-ascii?Q?YYrZ2GEOp4aW+7zZd7OmltPYB9tlvRZ7I8LaKgw9J6tOG3DUhuV44x2lAvOv?= =?us-ascii?Q?Ulskt3YE8xCuPUDH2TWC6fa+3zGanIeUnVerzEB4I7hDs2dAdQIRGFPaaSI+?= =?us-ascii?Q?/p9xl5ZNd97onvQ9gg5+7HKmDo2PFhGgSUz0FAP7UL6hBe8ejLwvRHV0zv8U?= =?us-ascii?Q?OgTKg4njTQe/rrTRhxLYx8NT1gYCDHxoVjqNBVbe1K3jmR75JRfPHpPqr+ng?= =?us-ascii?Q?zyMY+KUF22tR6mqZb6Ta0jt/lqiSkUSbJZDhmbNRKVx8mEe8Lo90cePmkMUz?= =?us-ascii?Q?m7abUwWQ4fS863mmhpgaoqXntSDC51sWSjTgaMx60+a2Hn4jL78h5v0Fkphl?= =?us-ascii?Q?uKDqnM0lZA79BtUDiIYKBUwAEh3pTwsJICDAKaTyb+acDwsRW9eu5segc18w?= =?us-ascii?Q?mU68AnPawCw46G6qwM+TADejhSUUCX5rjNsRA21VdSCXLJkMQmiu1DnY8K9Z?= =?us-ascii?Q?ehw6H55KBnnHtc9whkVsoMYQ4xODaaJI8Bsdf1ZQAhyJ1Y1vvWGlsV5nlkQ1?= =?us-ascii?Q?FzTtb6MI3B+6ktxeLWpOHy/kIVXKs4Hfn7wfgkMHxEgfW3CvGxM23M80cMFX?= =?us-ascii?Q?TxP4QdvPWiFuEwAQx4i0FVMvXePTmYFpSrH8Jvxz8PRGHgC3PrnQdevebNsg?= =?us-ascii?Q?ercuNRb8ZFWU1iika0qTQcCGZLidTy7fjgb0kSJDgNGLq+Qx0bz/dzhCO8YB?= =?us-ascii?Q?bFG9CnLiKOH3oKrYYKvTj52n?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: 673ee67f-4c05-49ed-6d80-08d93d3e4bcc X-MS-Exchange-CrossTenant-AuthSource: PAXPR01MB8415.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Jul 2021 09:46:42.1229 (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: iB2zV7FdUY6++7KVu6eh8x/VCPfomI8/5bSO78VUKBknp7/IpgC56/cHhE/9tv4uaySfYzQS1cax+FwJQGZqMA== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3PR01MB8113 Received-SPF: pass client-ip=40.107.7.110; envelope-from=e.fraga@ucl.ac.uk; helo=EUR04-HE1-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=1625219249; 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=fVJceJjQYvH9RQGhS79EI9vdUiffqmXB7tfOWmnxtpM=; b=otE8zWEkVlNQEu3jROhPPoay+4SE917OYpzCdRzbZ7zlu89iWdqhegr7tlvXmLiNj0wdR3 HeAS6IXhiz7YqYqvgcIBqltl3J5FGDn/15Y0YrImC2NY3Pt1bQ9k0aaMR89uZQc0D4UGmp +4YV2kuwyKooSww3GDFffXyMVITyWQ7x8iJJTd2cyJ+VpxeDx7bnHPYC5cXs9H8XLeXRfe 5XrBMoajqnp8z0HJ8P3Cbhdhk/6OaHT5wamQ2sXX6+XCBuA7tptijw/KafL1UKqE8dZyw8 uVK9unDj5R7CZ3lZmEBHl8bbUPTWUeOvdy/vsvvVc9i042bMagprBTtV6/Gwlg== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1625219249; a=rsa-sha256; cv=pass; b=iCm2MrFUA/gEFgb8RdL5QQK9XSXBsN0yhpZowC6p6e5m9C1AJpt4KtraPpHozQUdGv/Pld vNaVw8EOAf6HjTcYwhJJyL7AN19g0PamjdmW3iKhXd5SSRUIjf6W7alPusEpI33SVo/jqm Ps6fdZWS4vC+swe4NtBnpZkyGRjT9FpH6/ObkQAZyUQhsuygC2sibdnT7KWGEzJMgz1gMi 2Dsexq8iU8fQapPnXw9SUY+kbpj991lGqbAaQSthPPA+GVtdK6xBAVW2VZkL9eYZCwd5sI 0rpDY8KBOzbCDRl/8kFZ9S3NlOp8PrP7kOJ/gicHIhNeVVJLfII0i/kDEXOqOA== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=nydwGAqE; 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: -2.61 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=nydwGAqE; 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: 0F1BE1DFD5 X-Spam-Score: -2.61 X-Migadu-Scanner: scn0.migadu.com X-TUID: ELOfdlet08na On Friday, 2 Jul 2021 at 11:23, Uwe Brauer wrote: > No I only want to add the parts of column $1 and $2 that are between the > two hlines Okay; problem 1 is that org formulas are not really vector based: a range on the left hand side says that each element in the range will be assigned the outcome of the right hand side so the right hand side should not be a vector. > (I wanted to use hline @I and @II and not the explict row > numbers, since this is more convenient. But it does to work with > explicit row numbers Yes, you cannot use @I etc. in the range definition for the target. I can think of 2 options. First, you can use relative addressing, i.e.: #+TBLFM: @<<$3..@>>$3=$1+$2 where @<< means the second row and @>> the second last row. Alternatively, you can introduce a new column at the start and use the "Advanced Features" of the spreadsheet described in the info manual section (org) Advanced features which will allow you to specify which rows should be evaluated (see the * option). 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