[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Orgmode] adding up decimal fractions in the spreadsheet

From: Rainer Thiel
Subject: [Orgmode] adding up decimal fractions in the spreadsheet
Date: Sat, 27 Sep 2008 09:19:46 +0200

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

Many thanks again for this great mode
Prof. Dr. Rainer Thiel
Institut für Altertumswissenschaften
07737 Jena, Germany (EU)

reply via email to

[Prev in Thread] Current Thread [Next in Thread]