From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms8.migadu.com with LMTPS id MBcIJJkI82VYmAAAqHPOHw:P1 (envelope-from ) for ; Thu, 14 Mar 2024 15:24:25 +0100 Received: from aspmx1.migadu.com ([2001:41d0:303:e16b::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id MBcIJJkI82VYmAAAqHPOHw (envelope-from ) for ; Thu, 14 Mar 2024 15:24:25 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=P+EUjIVe; 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"; dmarc=pass (policy=none) header.from=ucl.ac.uk; arc=pass ("microsoft.com:s=arcselector9901:i=1") ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1710426265; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc: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=o9LQc0yP03EB5Ee7T0JEbg5vfhUIUfKrQ7vHmtO+Z0M=; b=CANEHc01nNUQRi9sDa47VPNqn+/Sy/i2Wm2q1It/kMAMH99NLL3tClYAROC4inNI9INQtb gWOBHGV60+83OW3EyBsKG9vvRH5lIJU4/NAKejP9x3tqM2BhjWYIWlJjcuFd1IKiPo75yE 3iIM9e9LsHb5X1JR0mZsRzHr8SG3Jna3WzlcapR1jiTU2V8JIpVa8CAJtWR2BxGFajMGni VNrsdfa52m/z2S4ml8WL17fAeZTStKAxl6bBJAr9Gc4NGIvnrGqgGWzCUmJbkGPvxe2YJ3 65yuYSoQSxYWQE57bJBJxeWUgUGBc2zMH07Z4eQO4XemUVCH6xOSgLP5HImTtw== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=P+EUjIVe; 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"; dmarc=pass (policy=none) header.from=ucl.ac.uk; arc=pass ("microsoft.com:s=arcselector9901:i=1") ARC-Seal: i=2; s=key1; d=yhetil.org; t=1710426265; a=rsa-sha256; cv=pass; b=q60qDevJjNVh4vRVL7MQg8zVVyfbzo1Ea1npjAG/iWD+TbyYcrAbioqSd/3n+xMbgWtDNV XMhqxTa5zLmON8KJK16PqyMNALHVyjnS8kNSjW1nLIFGov3vsx/e4+GXEmQ+zuxThOQ0/k K5s82mJI65z4ae6Z+1BBgs3Gx990kRG0jRsK2+eBkrkqnWGe7x8brX9WYVOLNfedtwcGRj m5wvB6uRKcqLY1d4vseaoniQ2UlahvmjUuY3c6yglCY84PS9zzWqEEre0aLqN2JHskszQb 32240xnEIS8ctdAsmUo1ydgDvvjkn5ldrAPaWcZdDwdFHp5jlD4ZWZ9AGhf3Kg== 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 57D6C11ECE for ; Thu, 14 Mar 2024 15:24:25 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1rklOl-00052L-Ea; Thu, 14 Mar 2024 09:45:31 -0400 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 1rklOW-00051h-9Q for emacs-orgmode@gnu.org; Thu, 14 Mar 2024 09:45:18 -0400 Received: from mail-vi1eur05on20700.outbound.protection.outlook.com ([2a01:111:f403:2613::700] helo=EUR05-VI1-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 1rklOS-0001wm-4n for emacs-orgmode@gnu.org; Thu, 14 Mar 2024 09:45:13 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=EPuvnUbROcHV0WRY6YZgpWL79HDcH0wDlAHeHEAz+AQBMDfg9GUskl22kv/1adCl/LEdAGe1zQNohK61CojPBPrYD24o1YWDBSzlAAVom3oWuBKUEtItqI7Rs5XweypuiaBxh+0hACmrnk0TcZpXD6ypMpoNAI12jJ5bGzIicksJOiKxSgD3WxT6lMaS8ncTDEsa7vBkxy14QftPqoP6c2JAGcSOJ3F7QhEMYFB3eSKkcwGcQxkGvrRe/pOckwyvXXxmhzbkIxgkxkpwPl6T4410UkfdEpY5xPeiMZiWBfHZgNi+BY/euBkNN+v2HVlj6jgnMak/4MhPDeYUZ8GMdg== 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=o9LQc0yP03EB5Ee7T0JEbg5vfhUIUfKrQ7vHmtO+Z0M=; b=LpLaR66pOzvAj4lVAxPHQGVl4U/0VqLKrV70Cb81P/CIPZwESsbF2b1TGGTIXN9sQNjhyM64yFtGXbbzNeXAymmxnk0dtEv97yPGORdKAy/WVkCIQZf9MEkV1NPhWKYXl9sA1SxgioKIxkaU/CNiPAVA76upuKW2hjPj4WdHkH4Uaieh/g88MwlgIZL6hPQ/cckbVl8NmdP4FB3ZZrwY59/qcjOr+lIqTlv4LgeAZJ0pGJmQhFREHW+KyIRV1MkL+riiI8lYxsW7onTyNxEh+iZGo/j83UpzPbruzUqRfQJLOI8lM8He0pWhJqDe7PnhA4ybTFKG7d2Q1DYgNPPIug== 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=o9LQc0yP03EB5Ee7T0JEbg5vfhUIUfKrQ7vHmtO+Z0M=; b=P+EUjIVeVfXualyuSvC2NS2vId/K0Kz8vc8otQPWi5Q5wP6/jqA9Sq3rjKdBUJC2Go88Q3kl1hPqE91gbcfJ4dOoeGsZWF9UEG1pBwXO2GLLD05pJU+3jF2DXyqZ1YZ3/RwXbFRd7hD0+EfgcTygudVtuiPVyPFku7AuHNgR0XE= Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com (2603:10a6:20b:4fa::21) by DB8PR01MB6261.eurprd01.prod.exchangelabs.com (2603:10a6:10:159::21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7386.21; Thu, 14 Mar 2024 13:40:04 +0000 Received: from AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::8553:d371:2bde:72bc]) by AS4PR01MB10249.eurprd01.prod.exchangelabs.com ([fe80::8553:d371:2bde:72bc%3]) with mapi id 15.20.7386.020; Thu, 14 Mar 2024 13:40:04 +0000 From: "Fraga, Eric" To: Wu Ming CC: "emacs-orgmode@gnu.org" Subject: Re: Table column formula with remote reference Thread-Topic: Table column formula with remote reference Thread-Index: AQHadFQCrmgMt/oQNUW4yL1bu46NkA== Date: Thu, 14 Mar 2024 13:40:04 +0000 Message-ID: <87y1alue31.fsf@ucl.ac.uk> References: <1F92C461-F43D-48F4-B153-1AD7B308D377@icloud.com> <87zfv3bj8d.fsf@localhost> <86F6BD74-10F6-4796-B1A5-23B4FB425336@icloud.com> <8734suxr7b.fsf@localhost> <196ADD6A-7FD8-4002-8C30-BFCFE71070BB@icloud.com> In-Reply-To: <196ADD6A-7FD8-4002-8C30-BFCFE71070BB@icloud.com> (Wu Ming's message of "Thu, 14 Mar 2024 09:16:11 +0800") 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_|DB8PR01MB6261:EE_ x-ms-office365-filtering-correlation-id: a0a37543-b6e7-48fb-c9cd-08dc442c4135 x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: wffjIeAQr8d39aEd8OczaN6yTVJor5RBFPwQc3vAvgk+PtEuZ6us5epunDX7+F5PtYm9SydhbBRKbJ6BvpZVha3rYx2g9NWeO7MOXd4aULU6VojWb0nsC50d8JPqG6cgvzWSl1vMcnzk/VosDkEDQCXvE9ApNnQOwBVu/0N5vqAR2wULzce1RtSyThDjpxg7+htqoAbMOeS4RzlvvBcVLkdk3nVhAAX+2PykpFXbPbmlDtHbnm0L4u7FQ8tl6hHWE1N+fNhg+QAAwqRZJzRRNoH5LpAoTfiuRfkTF1e7sH1U/ZAr/PTQDQWvDaLoqwSOKrQxHvRH4Ze8UwOPO/nOwd4ierMMD4nJLhtGt2+9vu6wrdiy+lLv+e8Yf0/GXGl27L8LoO6jc/IUGZuCH9bJ1anZrYGhc/bO72meDuDf7mN4n4W9Bncr4Ab+tI/cXI/y/CcK9uva74cqgDIAdLbfpT5kuVmQ7BSvxr5aCVpY7TG40GQGxdlgnvfFoDr7LgAA9sZ+p3yua0P2L2L/SSVvIE2XiUuQ+8PWsS30uokvLdbG/0PmiqKN1ht2KnzBt/dtEWZWAd61watiIHmjH2IhtNWzn5zfP6fnLtpH/aMRRijnfF0QivKGRB09gFtC/ivcSJHanjDlLRX3jaX+QJwFP0dJDO43Hitf8r0sn146lyDvQCs5/B3UU1i2TVHdifrTxlYZ+1R4xe7834TD7/lNth1fys5Zghs3mvQBqdJyj0o= 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:(13230031)(1800799015)(376005)(38070700009); DIR:OUT; SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?uamoiP5+9x/azsWlATr8ZR8JVhDtTJQDfw/5/THHhT4MNGG0ey1LY+2BI7?= =?iso-8859-1?Q?PeAYHHa8ZPsi8MsB6Ic/aMfzJLtNal3eTjSMu2xDa0dSl9WTYQvHZ5KV2O?= =?iso-8859-1?Q?AfhdxtOB/HDZjSH/wVeHtnLfzKLy81X1JYTdKekl+IxSJRo0Md2OcDFktv?= =?iso-8859-1?Q?G/jsBzKQpEyxaNawLMDMVhcio/CpTp4QJ4Qd6eE49bP+TfcIn9QZNwCVjG?= =?iso-8859-1?Q?jwaTy17ZP/gFM1woVKTn1Sx8ENx2aNLayNh0EbTi6lM5gWgSMorFjFpNdF?= =?iso-8859-1?Q?q2VknILOEvuM5Y8dPkM7oNMAxmG3ZZC4aKP6vA6+B8rDIPCdDSnJUQYMTO?= =?iso-8859-1?Q?+8oCmYq0v4skwjWiWpyqRNaItvUspwfJYDXGanBQeCoevpt61BSaBEgu4R?= =?iso-8859-1?Q?ZjdId9Cvnhwy8iVD+MCz0+0XvFNcEkCKoY6huC7eSUFCOznstxwYA6R2dC?= =?iso-8859-1?Q?lfxtRridULw1wgXIGyKZh0h86wCtUx7DJEGvgCkTTK0hmUawqIuP13B2oO?= =?iso-8859-1?Q?KUHxlkCQJOdDQSfXUnQMdvFtuJ3ib5COiCoMG/wckd7FFlZZnW3C6qE/fj?= =?iso-8859-1?Q?l5hrIjXIUG9vMhhuOGn8Iyi+xMmTxdrkLuBTRahNqKxr0/vVwBYOXYF3yq?= =?iso-8859-1?Q?VLr6jvz/rQetotkanN4QzeqgCWy6hjj054SuRGjDvoTpivLjwwB3tdyiKJ?= =?iso-8859-1?Q?gdcpt5Hmp7MhU9nKKz0nVOCwKAgVx8JaKZzn018aPyiHhvs6b+T0WgGeHj?= =?iso-8859-1?Q?wc5OI1+znevBDACgtugXb1InFpVH3cdaul136i7jtzXEvWk2Spvb01E+Oz?= =?iso-8859-1?Q?iEzXlft7D18wrM8fC6Og9dTpuxsdsLffYJIRtH13FlWiCgisC3hbf+MlND?= =?iso-8859-1?Q?GYPM50Q8W37SEb0P/Xwm9rMv2zOLnrZAyx5RcIEQtMjP4LVKG9yYgagxK4?= =?iso-8859-1?Q?xYj/XekZg0BhkK4qrdUwNUYxVPhQXhKjiyrU6jaqJT5sy/hPdd8xugCGN8?= =?iso-8859-1?Q?faQ5BX/A4hbYqcwe0sLg1u5PcA+4TtjkuMNKbooXG/6jtP7wQAbnxQKmOo?= =?iso-8859-1?Q?aTXzBxOvrlIzzjvjc+gpG/ru1c/Fz2766bpu19dI4uqHNyVaZBiMYBA/Mz?= =?iso-8859-1?Q?UCi/2Dts175sgUfhEIcavruwvl/wOw/LC0q902vS8Bk3G8u73T91o3Mi2L?= =?iso-8859-1?Q?68I76Rh0EuKIgXuX4+a8C5SOXDzVvpPlfVuSrfVdQlblrhU25ly1CgrwZD?= =?iso-8859-1?Q?60LDq+AWNQt69iHt7/A3feRfc4cF0rzIxhBSyGyQ1TAJ3xOrt+gY6StCUW?= =?iso-8859-1?Q?Vf8O4cd0hkVhmbNfDEPP/5Gzk7dNMvI29BzkaK9OYeE8qI8XH8Qx9hzkvg?= =?iso-8859-1?Q?lIXslNd2Re3SHSNhPHGIT1PGUCiURoz8lM2kVsgrKGLu5oKEfTb5D4BnQ/?= =?iso-8859-1?Q?L6RqewoUCY1iIdSEysvcTRn6Q9zgxOL3bxN+JXLFWjkong6/J6b1r4p6Q+?= =?iso-8859-1?Q?NRKlcJxRcv16ZdhBn9bYreNcCYdYMN9wmGSINqwMwkgNyrOFVw7A2Pah8S?= =?iso-8859-1?Q?FObTbfy74HXZ3uaieD791lTvHeHi9i8bE6Zvsh6173O//huo9PkNl7SyKz?= =?iso-8859-1?Q?/Vx2NzBL9t4vwNKSDYKvD9hq4xwzO9M+jL?= 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: a0a37543-b6e7-48fb-c9cd-08dc442c4135 X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Mar 2024 13:40:04.2970 (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: ljbcpD5b7Kafk1o/4L4+S544siqEVFddIohQUnAlfLusIKL0VGOO3BvSyAfon3IncdQc+N33f7w4I5ir/CTUtw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: DB8PR01MB6261 Received-SPF: pass client-ip=2a01:111:f403:2613::700; envelope-from=e.fraga@ucl.ac.uk; helo=EUR05-VI1-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, T_SCC_BODY_TEXT_LINE=-0.01 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: 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-Migadu-Spam-Score: -8.76 X-Spam-Score: -8.76 X-Migadu-Queue-Id: 57D6C11ECE X-Migadu-Scanner: mx13.migadu.com X-TUID: 9EQAZa9siWtR On Thursday, 14 Mar 2024 at 09:16, Wu Ming wrote: > Unrelated, but appeared on the same trial, noticed a cell was > mis-calculated. [...] This made me worry about reliability of simple > biz calculations I am trying on Org spreadsheet for the first > time. Please advise. I've not seen any problems with spreadsheet/table calculations in org and u= se it extensively. I don't use remote access generally however. In any case, one very nice feature of org tables is you can see exactly how= and what it calculates when you ask it to. Turn on debugging by "C-c {" (= org-table-toggle-formula-debugger) and you can see all the information you = should need to identify what, if anything, is going wrong. Turn off debugging with the same key sequence. --=20 : Eric S Fraga, with org release_9.6.19-1215-g67d937 in Emacs 30.0.50=