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 ms11 with LMTPS id eNITLq6LIWBRQQAA0tVLHw (envelope-from ) for ; Mon, 08 Feb 2021 19:06:22 +0000 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 9SDxKa6LIWCtLgAA1q6Kng (envelope-from ) for ; Mon, 08 Feb 2021 19:06:22 +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 E471194042A for ; Mon, 8 Feb 2021 19:06:21 +0000 (UTC) Received: from localhost ([::1]:36366 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1l9BrY-0004lF-Os for larch@yhetil.org; Mon, 08 Feb 2021 14:06:20 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:35646) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l95yt-0004vE-Ry for emacs-orgmode@gnu.org; Mon, 08 Feb 2021 07:49:33 -0500 Received: from mail-eopbgr60099.outbound.protection.outlook.com ([40.107.6.99]:60939 helo=EUR04-DB3-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 1l95yi-0001oL-IP for emacs-orgmode@gnu.org; Mon, 08 Feb 2021 07:49:31 -0500 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=nqc05lG4Jk2BOKJi3GffwNQ498vv7ncmhLZEI1J37qt6zsPfG0T+JJSquNlxtBbHsJVtVNdS1cKFbXyO1X74zYlJeId9nz0OarlRYhwwaSNKRTDY/qxeM9j00YqIUtpoV9ymOidpQ6F3MJsHp2Iz4Cq3xGd5bu46AWsL2V7/WFtb4XUzGGrGavwvWBKm2j+LQH++BzkivSFDqmXEH9YOz0Knb7GRN53tKq3snC2zvlaxWpTkz8bOQCgUtwF8mPStBkpAjDIe2/+sv/r3r8tV7B/13MXbiD0yRDtddZ9tKtRRWUZ6gldF+vQCveMf27048yrYAVD2c/zh28/G+Fgevg== 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=y9pmsmADjTFhyCI9kG7gqnHUpAxJHgprrU7C7fQ6vG4=; b=j4ELBgaz2NdVhw9RN5z0HtKNsotd3kgi80dKP7HkBzYYlw2aRCcN1F+2sKtUPfYW/Z8t/1xxW/NmzseCyjR6Cb8bKp7Zg1Nd3Xh/qAniFLMlVxqAJgFShzkMOWvW18lKIfXy9yJg0QfmfAcxXsczwKfZ2oYMFCSFrGwoqHgF6h5FPVSsj+kLZEPYJJqDVC/mioXBn05s2BwL4eryyYqNPCvGAA+4OFtxfhkK2G0S1IwdFmPWepR5UXHoSA2+zvbQyjfuEkQUkQl1S4YDd7R/dHEc67X4farDjnpGB4eTHCcMalnmX7ds4KRBEs6Lpl84SC4eMWOKfCNgKGeh1zqsKA== 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=y9pmsmADjTFhyCI9kG7gqnHUpAxJHgprrU7C7fQ6vG4=; b=Mbi5HWWK18IGdPMcEInFu45/Od3mPTdBvOKBEl4pFYwbsDGxV1CNKjk+b0viqc+CaYWRGHrQuOU6jn8yAdhyCWbB95SCc3rVjDdtcD7wa2S2ofIS8QGvln2F8+tY6iLyPhVu3oBjtVFnKUBzp/w8+tgx7baMX1gFcpWk6onIt8k= Received: from VI1PR0102MB3327.eurprd01.prod.exchangelabs.com (2603:10a6:803:10::26) by VI1PR01MB4989.eurprd01.prod.exchangelabs.com (2603:10a6:803:8e::20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.28; Mon, 8 Feb 2021 12:34:14 +0000 Received: from VI1PR0102MB3327.eurprd01.prod.exchangelabs.com ([fe80::9171:e6a:e540:66a7]) by VI1PR0102MB3327.eurprd01.prod.exchangelabs.com ([fe80::9171:e6a:e540:66a7%7]) with mapi id 15.20.3825.030; Mon, 8 Feb 2021 12:34:14 +0000 From: Eric S Fraga To: Emacs Org mode mailing list Subject: strange table calculation Organization: On the Interweb somewhere X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Emacs Org mode mailing list Date: Mon, 08 Feb 2021 12:34:12 +0000 Message-ID: <87y2fywxff.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: [95.147.101.200] X-ClientProxiedBy: LNXP265CA0028.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:5c::16) To VI1PR0102MB3327.eurprd01.prod.exchangelabs.com (2603:10a6:803:10::26) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from t3610 (95.147.101.200) by LNXP265CA0028.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:5c::16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3825.19 via Frontend Transport; Mon, 8 Feb 2021 12:34:13 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: ac5e16b0-f220-47d8-e81b-08d8cc2dd7ce X-MS-TrafficTypeDiagnostic: VI1PR01MB4989: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:10000; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: f6DHLAfN8Vonp7vNP1VZpUElcuYb/4t3WGcIdABMZYqgdchkBmcZ/p5dNdB0BKjhRKEzBTa4xFU1Shk2TdDcw3PQHBFWHzZWcoiEHitgVfqkG/3f6O6PAS/xLgQnjGeNziAIhNdImKbkaCmSQgRaD/X95TjIvKvtygKWOksVKhwkQCL7o9xRfIJGoL6+99i5uEgojaQULoWI/W7wVweFFVOwTo6ZSCxAQ1tI4C/cJ4KAjuPrYdQBqhRjFsKXk6RSVaSqJLKosVPagq3h7gNDOHvjsgjVI6JTMrdyTjpXK6e70COSahN/u9zeuOwEji76DXcBzMODX/zxJDX0Qi8E9/AzMTh35W5jbq7+Dsa6cOGFHVGLsg4GT8U5CI8eokjzrKI6ihi4otc/EdxJ9PfT40rCU8CA4qg4oeVVDtjeg26XvVL/FERSZSQImD83DOXp+hkk+dADu4MvfyvbAnmcR7lbetRS7BcXHO3alOAvettqz2gMu/XagHTqBXYWyiPr14Rpdzw4SqQSNoAxYQCCo8OIH04rE/MVa8WpwfA4S8L71Rg3TncKslgj73px42eJv/hbO1jU2ZuK/D4fxaCdiyWPhrbzCuABpLdXKWmu2zc= X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:VI1PR0102MB3327.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(39830400003)(396003)(366004)(346002)(376002)(508600001)(52116002)(4744005)(83380400001)(16526019)(2906002)(2616005)(6486002)(34490700003)(6496006)(5660300002)(36916002)(36756003)(8676002)(7116003)(86362001)(956004)(6916009)(8936002)(66946007)(186003)(3480700007)(66476007)(66556008)(26005)(133083001); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData: =?us-ascii?Q?zDH14dkWO/SG14XAI649O1yC6Q+VZiNs2Hoq+BwFjRzWXz/SJ0A0twhBXvu+?= =?us-ascii?Q?25IBJ3OvOaW7HxC3WvPyevZn/lb9/TJW/rImrevojYnmcZ5djb8vEZZijpX5?= =?us-ascii?Q?MstVoMHMozHtI+vMkx7okRaZL4dYh/hhUXhpOpnHdIno5B93vQzcD6FAJkSE?= =?us-ascii?Q?d80cCGWzW6qM4EV8tD70VI9cNe6/0uq7mRTWlBzU1ZSgZTgm7Nd7xQfpYFrq?= =?us-ascii?Q?nVX1DelKUnvK1o+hxlR4pTCQUF0i7absuT15L7LJwlCFiVLdaAaqoXbiPLlM?= =?us-ascii?Q?2yKZ8X8MV1JjYLFSqckYjspzrqw1YjKuiz2TyDbqwsP2MlRxhgQ0MQYW/suB?= =?us-ascii?Q?tGubY4Dzv2+9B8PQemFGbEHj+dtGtjgMv9zA2lkT0iDXbt6fXCy4KKyjIctE?= =?us-ascii?Q?1u9T88DmpCTW6nc5S0ABpXS2PRby+V56/a/762XOldgzv0Vm/hf49Y3ugClO?= =?us-ascii?Q?x9//Ce9RhpylqQZdvq8ZLO3C/a0bBtVocRnoR4Xcm2OQTOV5UALgAzuWLlg9?= =?us-ascii?Q?ZJQXNSE9hMwvZ/b41KtMtwqMx5uup5imLN37anJ2NiBOxRrPB2cMSjjCZfHX?= =?us-ascii?Q?R7WI+sU+2hlH+fOvwN14D3k1S4bLQiGxKwqrGLtfGswdP4zM7iLh+0G9k3tp?= =?us-ascii?Q?PRt6u47tKdOb/FwHJK20hRaAYbuaegT99GU3R4Y7HP7GWqy3jFyV/vHsvLS7?= =?us-ascii?Q?e1adPD7QEJpMGEqlOEHoOjMtwIUo9eh1X1U58GCtqv0R7pGRSdFKWuQOD8tT?= =?us-ascii?Q?I+k+hsUJn7YnQTqZeJ/i65qZQlaMUPBgL7ETfnYpDmQXIKXAFwqMlc2+T00Y?= =?us-ascii?Q?DluJzO2d/ENmd+4n8RWwSVGtW1TXAWMtV1qpI6inUr54rzAXDXRVXyn0eS4Y?= =?us-ascii?Q?+S0vj9SPd7nZl/IY1WA8k2/9H4d4GvG6JrCFS38mtQ1S75WdVF3GXlbtBwVu?= =?us-ascii?Q?fN73QODz6vhMLwSL2+d3HE0IbuShB2y0ZHgrzVaVKJ3/xIhL4FVWfKwN1Sfl?= =?us-ascii?Q?9PXO55RrtgHw5BgsIStKptfQpFKwTPs6UFiO30DWiIUltQ28e0FDBVc+YATS?= =?us-ascii?Q?C4R2I/JXsRHHjHNM/QtvX1pBcMXAH0g3nUh1s5e6OPsw5DN1exy8MR16dr0a?= =?us-ascii?Q?JRhZIvh6vOq3gfvGQVxxrGuw4HSXg5yPYLmL+PL6vB1vYmq0xpb6zCC+x01+?= =?us-ascii?Q?lxNwK1UZtiMEWSCF37Xf/Kx4wWfvTFALseMXttcfEx3f3VRG8B1o9Ta5mNmt?= =?us-ascii?Q?Nn7Oh5o/1CkUGPtaJqWYRMa2PAMD0ova4ISTAg3MYykCx1y2REriOfbTF2wC?= =?us-ascii?Q?7jOw+QrakMMmJC0P/XZ9CDjy?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: ac5e16b0-f220-47d8-e81b-08d8cc2dd7ce X-MS-Exchange-CrossTenant-AuthSource: VI1PR0102MB3327.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 08 Feb 2021 12:34:14.0670 (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: dMuYqSjp9FRevqRYqmHdX8PY/+4Pjt7dBSuEhcyIkoTLtpOJ3ZnO9wuu/4tTPEdvtxr3wxymhozjPVUcXL0V0A== X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR01MB4989 Received-SPF: pass client-ip=40.107.6.99; envelope-from=e.fraga@ucl.ac.uk; helo=EUR04-DB3-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 X-Migadu-Spam-Score: -4.06 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=Mbi5HWWK; 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: E471194042A X-Spam-Score: -4.06 X-Migadu-Scanner: scn1.migadu.com X-TUID: sl1t9IG0QHNa Hello all, I have an org table which is behaving strangely. The column formula for column 9 is: $9 = $-1+@-1$+1;ENf2 This should add up the entry in the column to the left, i.e. column 8, with the entry one row up and to the right, i.e. column 10. However, when column 9 is calculated, any entry that is immediately after a horizontal divider line causes the @-1$+1 to be replaced with the value from the current row, not the one above. Removing horizontal lines fixes this (although not entirely as I get a different behaviour later down in the table...). The behaviour of @-1$+1 seems fragile. Has anybody had similar issues? I cannot create a minimal example that replicates this unfortunately and I cannot post the table that is exhibiting the problem. However, I hope somebody might have some idea of where to look... Thank you, eric -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.4-213-g49364f