From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp10.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id cPtJLHnSCWR6ngAASxT56A (envelope-from ) for ; Thu, 09 Mar 2023 13:35:05 +0100 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp10.migadu.com with LMTPS id wPlbK3nSCWStewEAG6o9tA (envelope-from ) for ; Thu, 09 Mar 2023 13:35:05 +0100 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 3451489CB for ; Thu, 9 Mar 2023 13:35:05 +0100 (CET) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b="F+m/gaNS"; 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"; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1678365305; 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=T/DQv6gfmMZhh00zLVBGCgIf0cIyrXxukUfXAICLe5U=; b=eFBs+37x8y3Lx+MdmsBKygZx2k4EWmst33MoQ81O8Xz6D3EgtGJprnIjVlsYGoKD0t3KLa g3duerSxbzikICQ4AvS3eHfjhEynX8+bzDGp/L/A2mfGLyAOMnB+VVHXnGIv9dTlwK1UUX s0r6oDXuR5jCOXJt4zT27N581X2st1n4UmlG1jl44UhiHauq6ujEnKziCadcNBAw0Z1CBC a8J6AdCyi0uteqI++uN147VDqSFm5NKoRG1OAldfX6nAdk1VtoFvW/nUqlXNnHSlOSYpo/ JYxd6QP6dtenOm580Hgfe1vMvlnpv9ELup1AK+TDlawL3AYrrDaR8JfbWjwL/w== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1678365305; a=rsa-sha256; cv=pass; b=Dyd9aZ/u9Hb6C43A59JNsIY88xxeANllIvcueJ8GeZHPTgGRQ544Vnzqpd+GYq1Igfl6OT nQSuPWImFPfNy5YXQm1v+w/X/LiKFtyVTrN9rvzphPAQ/aZ118NR9uML/lQYYSwWfp+gm8 ZpJeAqkOFfHdPRk69JvD9PcNLdo/fAE3CaUIjWRQno186ZTTvE6l44kZrLSwb/TinaU7fa 3+P6yjJh+9R76R5BhLH/94IItyUtxUNlWLwp8/6OPd57Sh12BSQ9/gOPgTmKyMmgyzdOjF b+YUqNcfwLjI8tw9or0Ix6FBrxrKpvPsD+xC4Px/bc6CTMI26O1LddtgdBQcdw== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b="F+m/gaNS"; 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"; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1paFTH-0003u8-0G; Thu, 09 Mar 2023 07:34:11 -0500 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 1paFTE-0003sI-UR for emacs-orgmode@gnu.org; Thu, 09 Mar 2023 07:34:08 -0500 Received: from mail-he1eur04on072d.outbound.protection.outlook.com ([2a01:111:f400:fe0d::72d] 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 1paFTC-0008OC-MO for emacs-orgmode@gnu.org; Thu, 09 Mar 2023 07:34:08 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=gZD8/bK5JW0kn6GaOMiNx5auSzfXleqsZkzmGqHpvmAYaAQGLeJHSCD9SbDGvppOG1u6XoJkI8jxnFGM8v9nPqMUZpOjuBROQ7+HCRJ3ogMeZa9/1FhACTmEERFMqejPXTlHerOjl0kkLQ48qRXWhc+YWl84gymKEYqWdE+PLk3ddOEv/2waV7CXVY+6wsGbhnTvjmzLBPaiDwzSvtNGIMtOq0RRsyw/NX4HCIQ7OAfapF3C8ZPTt3kqJhNV84fizYI/JOUqPTCPiGsdF99dJQmT3pyTYw5KGfnpEjMbbFX8nKtrfF/JJ6cHeAL6x4QaKIM2wd83FwWTtdAdTZZ/tg== 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-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=T/DQv6gfmMZhh00zLVBGCgIf0cIyrXxukUfXAICLe5U=; b=IUJo5MTkGlwrev+YsqzGp7Slj1RDgoL+bUce5amHXmrbrPJmYlYoNWHGETkuWZGryHerY0dKhxb60BqZMkOBZTQ/p0DzxNBM4rgphdUBvwsOPlFyAYw6pi2E0YPpBRlfE1Nrtd5f6IE4mCww+1wGOfl0ypFe0QvqeQVjAjMQbtVVBkeK+nCi8rfzwvCdvwWyJfJfsRJarKe6sOmZvz0k/jR2klHy2hfALkXyyPFHi8MMjVtrWPN0X95uoRLejS689N5gQIPJjeJGiWWDn0wDi0xYeD1UymQPpiQXzRp/rBJ54Xx3YlHUzUNXZf9xbFRsqueziNyq1tuePlnYqywj3A== 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=T/DQv6gfmMZhh00zLVBGCgIf0cIyrXxukUfXAICLe5U=; b=F+m/gaNS1rnY+pnr5A7ySkmeTHAe+cyB7JJEszIGSE/31ANUOvSD2X8gIFMSFi5mKjvmIlebfUnEJFTP8VpcjK+rB55unATPePQ5lAoVh/t4VjcC7HcF0i6KmdrRJ8VFmr4Guyduf5DRxsi1fvO/c8fT4QWC9tkR2pjqJ/DIg58= Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4fa::21) by AS1PR01MB9155.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4d5::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6178.17; Thu, 9 Mar 2023 12:28:57 +0000 Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::3437:90f5:87a7:bb47]) by AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::3437:90f5:87a7:bb47%2]) with mapi id 15.20.6178.018; Thu, 9 Mar 2023 12:28:57 +0000 From: "Fraga, Eric" To: "emacs-orgmode@gnu.org" Subject: Re: How to exclude colum titles from calculations Thread-Topic: How to exclude colum titles from calculations Thread-Index: AQHZUnSSJ7ly2eRizUWRftWwzvRuxA== Date: Thu, 9 Mar 2023 12:28:57 +0000 Message-ID: <87zg8mjegn.fsf@ucl.ac.uk> References: <878rg6nqxv.fsf@mat.ucm.es> In-Reply-To: <878rg6nqxv.fsf@mat.ucm.es> (Uwe Brauer's message of "Thu, 09 Mar 2023 11:45:48 +0100") Accept-Language: en-GB, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: gnus (Emacs 30.0.50) x-url: http://www.ucl.ac.uk/~ucecesf/ mail-followup-to: Org Mode List x-ms-publictraffictype: Email x-ms-traffictypediagnostic: AS4PR01MB10249:EE_|AS1PR01MB9155:EE_ x-ms-office365-filtering-correlation-id: eec76c4e-6747-4480-fb87-08db2099dab6 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: a4asfevmotgB79i03pS1IiF11wlY6+RT3naAOBcF5qKBFdfZ1Bke0UtlkLIzxrGMC0Ef24OOmcF34Goc/h1tI+Ta0hSNklyU2zmW+nnVWbuhvUchEHPKJovThubBfBRW76a+mfL66rswCM7oUjnNX2J/Rn92wtBO9m1CYlzwc5tyHn6PUgFqodU7rHUEJ5iNmBKLPDOhAv55F3gNzUyOr91LzFSPwDgqzPBV8br4otvlLzt8SzOnDMK2zjQOA06AqOreIj8M1yzO8mr2R66crgM/eNCh0UyKrmS1ydtWRTPLr0Txk5N/A72+h0vV3hBWMr0jSELtn9zu+LgvU92uLgX4zIp9e4hqFMhpxnRMQ9ixrAT2ME9AgGmOfImheLri+g86gywGdfqjao2I5Zo7lngDw/cjY3VBARUEInAFP+nsDSAFw5uoBpz7EopWH7RMN+B4ychHZOgy3FuYhkg6HdJiiPVPTdFI/OtsiYSpvz+s6ZnwbRzGX/f7aY0Ks7JAuni14i90dh6kZ2w8LgYb7eY3wDBUiE1a/En8ntTEgYRh6QdvdI+cWyuidkNjmn2M6BIe23qAKd3Pkmyz7z9elU8AHy9ClL2+VzUygDU4cOwTcsYrRxKFXUJSc6Uyry5z0THVLuL08RXA4j86vSBJ7appdZoNE682yl8Y5b+HF5X7SMGHB7IAfggLoh7emfqCdHtiKyUAJ+KyqqwGJNFeNA== x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:AS4PR01MB10249.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(13230025)(4636009)(136003)(39860400002)(376002)(366004)(346002)(396003)(451199018)(478600001)(2616005)(5660300002)(4744005)(6486002)(38070700005)(36756003)(2906002)(83380400001)(186003)(6512007)(26005)(6506007)(71200400001)(41300700001)(786003)(316002)(91956017)(86362001)(38100700002)(41320700001)(8936002)(76116006)(122000001)(6916009)(66946007)(8676002)(66446008)(66556008)(64756008)(66476007); DIR:OUT; SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?avspexZrWjG5jFeLravxKUuiqXutuVM9JoOVkFXkyVBOKedGiHRItIXH3q?= =?iso-8859-1?Q?QDDAxObJ/Yu8hOxBL1wU9GdiwVimpyd3FUIy1lspFlgwut0gpHMEaSpmxT?= =?iso-8859-1?Q?bLzQOA053+pAJ1mU7awSnJ4WNd85DaqbMZhh7T+OjGpH6B5iV2lW9FlLih?= =?iso-8859-1?Q?n6J9k2PiOsZaWCS5d6KMiIaImvTpTETky4loKGIObMEFEUh7C/76IXfV/d?= =?iso-8859-1?Q?hOwCHy6qO3dSuH+yYwMxFW4KbeA1kPTBi8X/YkwTchZtg/kGBS75F6q27G?= =?iso-8859-1?Q?NkBmQlzk0tVRqNfyTptnNxs590NJPskyLdkFnOLKIrDpcM5X93dHvG+vqb?= =?iso-8859-1?Q?23W2/0dpJTxE+1a1tQPJiwV8pguSksgV41csRg2y6i9IHs8ZzisHHPrpz3?= =?iso-8859-1?Q?X08me6mNHXHgv3RRSlGBaVCuO1Qmwckt9bMD3FL45Wxs0FRfqOmdmtx7xL?= =?iso-8859-1?Q?BvhkdYyXsHlZ2cGIC7wkDiW5nDc78nZUfL4L9YlgFD+R8xPrhQKVCYRzSh?= =?iso-8859-1?Q?Gsnbw3lge2Sir6+CTJwWmO+di+Ha1AqENw5DIMRu1n4gtibdX+XxZZ2dmX?= =?iso-8859-1?Q?HbuNt8IRSYlAcamkuKqfzIBDcSfKTiQ/EHXGqaHHqwTLDYSCUZj8W/5Wan?= =?iso-8859-1?Q?2JEtY6ykerQ6uwrM5xLUuVy4JYjb8NeXSeW2C7F9tSHc0MfJ37/2XHxWz3?= =?iso-8859-1?Q?8aAg8TKz6X0bHxEMUgDkSsTt4oXb6H9ZPI4mEiAu3LoDpfAZwUlaVhwU3m?= =?iso-8859-1?Q?HyvTEcQR7mP5naqqUq+UR2KrmqG1RKsav0LPoiHX1P5lPBYk0ruWPGHTJs?= =?iso-8859-1?Q?sAPxDeu7dZnUwq8NuaGBLQfIG+aTNmzg8ed3xsVK9rXxt/SLs2thNLUnyJ?= =?iso-8859-1?Q?sM8wvjR6S6g9IzhGj7Ky20M8Gk2iKFvUUWtdxfLlS4p2t6uXBZgiuILVMc?= =?iso-8859-1?Q?mNsSKUejJqfcJpK2+LqitUhs3JHmzi+NwUbeQCbqqqKz4leBlooCNHhCW2?= =?iso-8859-1?Q?VVZ4BV9AczLduQDiXNIPrd8xf1bgIm6myyJC5awvl9KEnn48V/Tohs0nXX?= =?iso-8859-1?Q?8seTthIXE+I2SKpnx2fWTQN1Mv90AWADHWTF8gUXlIzfBkgXgioPxdvWuN?= =?iso-8859-1?Q?quYSs8OI8Mdu3CFB0SOmaHbsw9U3G31XcT4gONW/YLY6xMydyLfrj+bRmE?= =?iso-8859-1?Q?KyMH4t8jRovISBVELmy+UtdphxdYKI+n5PA4hab1LT5iIUts/dzMKVxMsB?= =?iso-8859-1?Q?En+HNT7kxe5zRMToyJgTSNtJGXL6NL74urS3NFdROz3QSMTpgt0d8s03ch?= =?iso-8859-1?Q?RgVz/JEJKYno2lSSDmR/Jhcr0cHQ7PlaDa3kgVJNY75p8EuXAGV3dC3tYj?= =?iso-8859-1?Q?UGH8xh6Le0axMJf+VXKsLLiTNkOGGQ77uJBvnQXj1atTkw1J3bXtTXduFm?= =?iso-8859-1?Q?CdfTM2tIeVDnkD1bDSUFZWGACQVZuJ+KVTFmVhkMM22ofLhLLRz599jsAy?= =?iso-8859-1?Q?16d9tIvMp8TuFaRqw3p3ak0W4WA+RFbZPTR+g2qMT67t7F7ivQTAnig8nn?= =?iso-8859-1?Q?tL2mKsz2OM28ptLVXN+0wI0WZQV9QO0sxv0JIgTedN5x4b2UHrL4S/bm4F?= =?iso-8859-1?Q?GemTOEMfjJ5ZQKR9nMShp/cNtbbr1oPqFO?= Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: AS4PR01MB10249.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-Network-Message-Id: eec76c4e-6747-4480-fb87-08db2099dab6 X-MS-Exchange-CrossTenant-originalarrivaltime: 09 Mar 2023 12:28:57.4411 (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: jdrwLY9FsTdqjC+voUoimHcah9R54xZQyvpHY+Ly35aHicALVBEV8+OgzCUxAPXIioPi5pHJVr9lgxGIrcnOrQ== X-MS-Exchange-Transport-CrossTenantHeadersStamped: AS1PR01MB9155 Received-SPF: pass client-ip=2a01:111:f400:fe0d::72d; 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, 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.29 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: X-Migadu-Scanner: scn0.migadu.com X-Migadu-Queue-Id: 3451489CB X-Spam-Score: -8.87 X-Migadu-Spam-Score: -8.87 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-TUID: ICIa/Nh6ctDj I make extensive use of the advanced features of the spreadsheet in org tables, specifically having a first column that indicates which rows should be calculated or not. Check out the org info manual (org) Advanced features and the token you want in the first column would be '#' for those rows that should be calculated. this will allow you to exclude the second row from any updates. --=20 : Eric S Fraga, with org release_9.6.1-278-ge52c53 in Emacs 30.0.50=