From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Rainer Thiel" Subject: adding up decimal fractions in the spreadsheet Date: Sat, 27 Sep 2008 09:19:46 +0200 Message-ID: Reply-To: r.thiel@uni-jena.de Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KjU5m-0002iU-O7 for emacs-orgmode@gnu.org; Sat, 27 Sep 2008 03:19:50 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KjU5m-0002hr-5g for emacs-orgmode@gnu.org; Sat, 27 Sep 2008 03:19:50 -0400 Received: from [199.232.76.173] (port=56392 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KjU5l-0002hh-Up for emacs-orgmode@gnu.org; Sat, 27 Sep 2008 03:19:49 -0400 Received: from mx20.gnu.org ([199.232.41.8]:63651) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1KjU5l-0007D5-KI for emacs-orgmode@gnu.org; Sat, 27 Sep 2008 03:19:49 -0400 Received: from yx-out-1718.google.com ([74.125.44.153]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1KjU5j-0005Dc-T5 for emacs-orgmode@gnu.org; Sat, 27 Sep 2008 03:19:48 -0400 Received: by yx-out-1718.google.com with SMTP id 34so217394yxf.66 for ; Sat, 27 Sep 2008 00:19:46 -0700 (PDT) Content-Disposition: inline List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org Following a hint by Bernt Hansen, I have now changed org-table-sum to (format "%s" res) until I'll be able to use the corrected version Carsten Dominik uploaded to the git repository (which I am not sure how to access). Even so, org-table-sum at times shows a strange behaviour. When I try to sum up the following table: | 12130.68 | | -1444.19 | | -12744.90 | | -186.00 | | 7000.00 | | -7056.00 | | -335.58 | | -277.00 | I get -2912.9899999999993 (-2912.99 being the exact result). This is something I'd expect when square roots or logarithms are implied, but with such a simple addition and subtraction of decimal numbers I'd be inclined to call it a bug. Is there a way to improve org-mode in this respect? Many thanks again for this great mode --=20 Prof. Dr. Rainer Thiel Institut f=FCr Altertumswissenschaften 07737 Jena, Germany (EU) r.thiel@uni-jena.de