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 Ex0oNlgEbV+4cAAA0tVLHw (envelope-from ) for ; Thu, 24 Sep 2020 20:40:56 +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 8K7UMVgEbV/TQgAAB5/wlQ (envelope-from ) for ; Thu, 24 Sep 2020 20:40:56 +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 8631C9403D6 for ; Thu, 24 Sep 2020 20:40:56 +0000 (UTC) Received: from localhost ([::1]:35100 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kLY2x-0000qG-HZ for larch@yhetil.org; Thu, 24 Sep 2020 16:40:55 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:59770) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kLXXy-0007CY-Fl for emacs-orgmode@gnu.org; Thu, 24 Sep 2020 16:08:54 -0400 Received: from mga05.intel.com ([192.55.52.43]:51988) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kLXXw-0003Wi-D4 for emacs-orgmode@gnu.org; Thu, 24 Sep 2020 16:08:54 -0400 IronPort-SDR: peI6s4ccM+7rq5DrHywClkz6Qjoneb61/Gs2NvvJFrvCcjnLDyZ1DcpgPVVDUewWCw21Qoy9gw ga4L09ooeNCg== X-IronPort-AV: E=McAfee;i="6000,8403,9754"; a="246137474" X-IronPort-AV: E=Sophos;i="5.77,299,1596524400"; d="scan'208";a="246137474" X-Amp-Result: SKIPPED(no attachment in message) X-Amp-File-Uploaded: False Received: from fmsmga008.fm.intel.com ([10.253.24.58]) by fmsmga105.fm.intel.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 24 Sep 2020 13:08:49 -0700 IronPort-SDR: HZvmssbPaAAN/bhHNzTRhlT79mj3h1gUQiCdpuXqKryy/qlQdMS9Yvv1dDk7jbaHXr+tYRBId/ /kx24XeneWeQ== X-IronPort-AV: E=Sophos;i="5.77,299,1596524400"; d="scan'208";a="292230066" Received: from nalbalas-mobl.amr.corp.intel.com (HELO crane.swizzler.org) ([10.255.228.59]) by fmsmga008-auth.fm.intel.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 24 Sep 2020 13:08:49 -0700 From: Mark Janes To: Kein Test , emacs-orgmode@gnu.org Subject: Re: org-table-sum In-Reply-To: References: Date: Thu, 24 Sep 2020 13:08:48 -0700 Message-ID: <87pn6bc4z3.fsf@crane.swizzler.org> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: neutral client-ip=192.55.52.43; envelope-from=markjanes@fastmail.fm; helo=mga05.intel.com X-detected-operating-system: by eggs.gnu.org: First seen = 2020/09/24 16:08:49 X-ACL-Warn: Detected OS = FreeBSD 9.x or newer [fuzzy] X-Spam_score_int: -33 X-Spam_score: -3.4 X-Spam_bar: --- X-Spam_report: (-3.4 / 5.0 requ) BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_MED=-2.3, SPF_HELO_NONE=0.001, SPF_NEUTRAL=0.779 autolearn=ham autolearn_force=no X-Spam_action: no action X-Mailman-Approved-At: Thu, 24 Sep 2020 16:40:28 -0400 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-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=fail reason="SPF not aligned (relaxed), No valid DKIM" header.from=fastmail.fm (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: -0.91 X-TUID: U6qKgXSYUNXV I can reproduce this with org 9.3.1. I imagine the decimal numbers have precision problems when converted to binary floating point. A simpler table to reproduce: | 83.6 | | .1 | |-------------------| | 83.69999999999999 | Kein Test writes: > Hi, > > I found out about org-table-sum yesterday, but I quickly ran into a > problem, where the result is not right. > > For example: > > | 171.00 | > | 4.07 | > | 4.44 | > | 2.61 | > | 12.21 | > | 6.69 | > | 19.72 | > | 23.09 | > | 6.23 | > | 15.28 | > | 250.00 | > | 250.00 | > | 250.00 | > | 78.85 | > | | > > If point is at the last cell, org-table-sum evaluates to 1094.1899999999998. > > I did not find a way to reproduce this with other numbers, but the > order seems to matter. > > Best wishes