From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id mMnXLyXyjl+qLQAA0tVLHw (envelope-from ) for ; Tue, 20 Oct 2020 14:20:21 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id 0JqbKyXyjl/TOgAAB5/wlQ (envelope-from ) for ; Tue, 20 Oct 2020 14:20:21 +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 DEC379403EC for ; Tue, 20 Oct 2020 14:20:20 +0000 (UTC) Received: from localhost ([::1]:59428 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kUsUt-0005zx-1b for larch@yhetil.org; Tue, 20 Oct 2020 10:20:19 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:40128) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kUsUU-0005zq-K1 for emacs-orgmode@gnu.org; Tue, 20 Oct 2020 10:19:54 -0400 Received: from mail-eopbgr10134.outbound.protection.outlook.com ([40.107.1.134]:39846 helo=EUR02-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 1kUsUS-0007K0-3U for emacs-orgmode@gnu.org; Tue, 20 Oct 2020 10:19:54 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=cmiJZFM+gsN/1rYD87yswgaGwy7Ql+BcD5yo4m0JuqD/uL2+hGUrfjThrjuAqlYaTqiU9JV8zst+ItBuSAEN7VyHXjigr/p2MQoUV3Df5kcRNRo0ewpUs/1htpRkFukcJXacBbYVP34Fl0zL8GroCGOmYmGAiZLkJLumbmUJdwuS77lS/l4RXpTETibpN5sn/WYk2bpU2Hq7omJ1JlQ3eHs7ZFGTMjN2scPUbiYt/O3f5HOCb1F3u8n+oLpB7Na1R/mR0R/3Ez/IqSrcsDjiSDohdfHGA9iN04dI1ycoBd1tP9r0hSoj+qlKQtTpttOSA+tfoiOlQuWbqiTfY2feSg== 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=48V4ReES9d2P8u4D9iZAdb2DOmdk9nlWgQ/SEg062xA=; b=YLYt68XEA5fGzj/b5bTldqx+AA26iprbaVJ0gf63s3d9yPMczd7cDOEGvzRhYCML65tXcIRjlmIP63od85/NkwGLptzS6QWohv6a/0nBu1BT4SX2MFoD9kDKif+4Nr8JEJFRuPeLPSoqb2LighFNgnDQLECvvvMaT9wvGEddKprHj/viPfGfdH/qyPr9waVCgz30CLVZcoS5ZOBIgrksKyPYhBA+asDFYHmku54W6Pe7YkLLeIqOGqjTpRgJdDO8aW2qUuyQMDfyCPOyibMhpak1Jmxu00VYU1cmXHE7oAC98o6EsbgJ9aMUaqF45kNVshQF3UCgQf1IhfBVltY2YA== 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=liveuclac.onmicrosoft.com; s=selector2-liveuclac-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=48V4ReES9d2P8u4D9iZAdb2DOmdk9nlWgQ/SEg062xA=; b=uZkAdXoP+TDFXNAp1GuB+8QoCNfMTotc5TYxhxcRUhxYOu81hXeYy/zoW+I3+sznHSqffXBQ0FrNxhP7Wju02JwB0XkgM0Y1QDDfVD/iU9CLINcJvNbunrDffedjNeNASvo4p0EtiKlJevUmi7dcricf98Dug7v82CUxasUEfLc= Received: from VI1PR0102MB3327.eurprd01.prod.exchangelabs.com (2603:10a6:803:10::26) by VI1PR01MB5117.eurprd01.prod.exchangelabs.com (2603:10a6:803:ce::24) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3477.27; Tue, 20 Oct 2020 14:19:44 +0000 Received: from VI1PR0102MB3327.eurprd01.prod.exchangelabs.com ([fe80::25b1:725d:4a8a:1813]) by VI1PR0102MB3327.eurprd01.prod.exchangelabs.com ([fe80::25b1:725d:4a8a:1813%5]) with mapi id 15.20.3477.028; Tue, 20 Oct 2020 14:19:43 +0000 From: Eric S Fraga To: Daniele Nicolodi Subject: Re: [PATCH] org-table: Add mode flag to enable Calc units simplification mode Organization: On the Interweb somewhere References: <6d8c15c2-d1b0-d913-df39-c60381cff70b@grinta.net> <33143b05-a298-8277-313b-3a1deb69ad27@grinta.net> <87pn5dui49.fsf@ucl.ac.uk> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Daniele Nicolodi , emacs-orgmode@gnu.org Date: Tue, 20 Oct 2020 15:19:42 +0100 Message-ID: <87lfg1ught.fsf@disroot.org> Content-Type: text/plain X-Originating-IP: [95.146.75.135] X-ClientProxiedBy: LO2P265CA0151.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:9::19) To VI1PR0102MB3327.eurprd01.prod.exchangelabs.com (2603:10a6:803:10::26) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from t3610 (95.146.75.135) by LO2P265CA0151.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:9::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.3499.18 via Frontend Transport; Tue, 20 Oct 2020 14:19:42 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 59b6adf3-d7f1-41e9-4134-08d8750330a6 X-MS-TrafficTypeDiagnostic: VI1PR01MB5117: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:459; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: I7q0wA3NVzZm+NRgqPulSkbgJWcVCmsJBH9XkrVCql7YEq8itKtqchsX1ELsCchjVKZ3n4BviTQ61rsj3W5aglAjEL9/LfZc7nUFndhbiSm+VuN3UjPci5+JDuwS+MHFa87iqOTJr9HWhFNX/+XAbsjwGoMafx+tvmQGmbFa0vj83gNikQ9xXieSoKBUyGJ6f6B3FbIKq+cZNsyrRej6kF+FH7ZCqg+gkkWlRk1PjILgltrKGjX/2kHGkx2uNqVIDn4Wr3HWcVVJkV+HY3Uy6Kcwu9xuS7IA2piV1dGC2eibKoNX8SD3dk5Fp1HYcy9C 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)(136003)(346002)(39860400002)(376002)(366004)(396003)(186003)(316002)(478600001)(26005)(2906002)(4326008)(9686003)(956004)(16526019)(786003)(6496006)(86362001)(8936002)(6916009)(8676002)(66946007)(36756003)(5660300002)(66476007)(66556008)(6486002)(36916002)(52116002); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData: zAe89VyEEYjTRgmPSSFQrA/vM+EBqKFFR01tnEKSnuFq0JhACHnWXGECwgMzszrFd8LPJICp6hOhNXm5M7uMOwJOnutCGMQ0kAQk56Y2MZJUiz7hF1rqvhEpf+M8WrxpIT3ccDji6Kf+uC9jjAV0Y/DJNAwJm923V476gib9fQcdKcK/xAyhJw7oWVQS0C+7L+EKSX0H4qV/18M+0dTp+mUTqK8GdslEetioCMKEiXxa4D8TOKPNHJD+e6sLr9n76iex3HQ4rm2Lywls4MY+2sC+ThK/7q4InzskA3SOpmvZixKKFBi1u5NX6KLecBKNQVw0WRIjNouGeVp0UEJf/JFnb4JyM8M6IXvrDA6Zx0KE7ptpgmqWd60RjMwaVp0JVVfSIV7u9I+hEyXT5pCxhGFveiiIQOfxe0rR4ZEpk8O0e/4RzcY0NmS6YZhU203j43RpIbLAWBq4J7JaUGfBG8gC/MJzQabvU/DSfeEIdY32trz3Gsn07gZ6ETSZCNLq0dRiRWPt/oxdcp3vnMF7kMxBw2sBkV854VdPuCYGhV19OZudJpiqn2pSrt1kX87ZqWIT480xB65LWwhSwDiCOUCF6QCBpZSYOg0bEP2lQEXOgQ9pNqHWDKvANPqdKEXuUUwrzxxDF3fW90e/YIZHIQ== X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: 59b6adf3-d7f1-41e9-4134-08d8750330a6 X-MS-Exchange-CrossTenant-AuthSource: VI1PR0102MB3327.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 20 Oct 2020 14:19:43.9016 (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: /uqtyt2ethk1T+PGFzQQDk/wY6ETG67Cau7CTLJFXxUD1m+FL/xhIrp7xlpDqd8bBmJFnVYMyWE6SSXJjfbFhw== X-MS-Exchange-Transport-CrossTenantHeadersStamped: VI1PR01MB5117 Received-SPF: none client-ip=40.107.1.134; envelope-from=e.fraga@ucl.ac.uk; helo=EUR02-HE1-obe.outbound.protection.outlook.com X-detected-operating-system: by eggs.gnu.org: First seen = 2020/10/20 10:19:44 X-ACL-Warn: Detected OS = Windows NT kernel [generic] [fuzzy] X-Spam_score_int: -15 X-Spam_score: -1.6 X-Spam_bar: - X-Spam_report: (-1.6 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, FORGED_SPF_HELO=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_NONE=0.001 autolearn=no 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: , Cc: emacs-orgmode@gnu.org Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=liveuclac.onmicrosoft.com header.s=selector2-liveuclac-onmicrosoft-com header.b=uZkAdXoP; dmarc=fail reason="SPF not aligned (relaxed), DKIM not aligned (relaxed)" header.from=ucl.ac.uk (policy=none); 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-Spam-Score: -2.11 X-TUID: f51Eyy3aFZkM Hello again, Following up on myself. I'm seeing some strange behaviour although unit calculations are working nicely. For instance, this table: #+begin_src org | stream | a | b | c | total | x_a | x_b | x_c | | | | | | | | | | |----------+--------------+--------------+--------------+--------------+-------+-------+-------| | feed | 1.05 mol/s | 1.05 mol/s | | 2.10 mol / s | 0.500 | 0.500 | 0 | | effluent | 0.74 mol / s | 0.74 mol / s | 0.32 mol / s | 1.80 mol / s | 0.411 | 0.411 | 0.178 | ,#+TBLFM: $5=vsum($2..$4);uf2::$6=$2/$5;uf3::$7=$3/$5;uf3::$8=$4/$5;uf3::@4$2=(1-0.3)*@-1;uf2::@4$3=(1-0.3)*@-1;uf2::@4$4=@-1+0.3*@-1$-1;uf2 #+end_src does not seem to pay attention to the f3 mode in the last column, first data row. I've also seen some (difficult to replicate) problem with column widths where the columns are much wider than the expected. I'll keep playing to see if I can isolate the column width behaviour. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4-61-ga88806.dirty