From: "Rainer Thiel" <r.thiel@uni-jena.de>
To: emacs-orgmode@gnu.org
Subject: adding up decimal fractions in the spreadsheet
Date: Sat, 27 Sep 2008 09:19:46 +0200 [thread overview]
Message-ID: <d6b6c7740809270019s5b2d6a83k7ee7cb2ad8e165ae@mail.gmail.com> (raw)
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
--
Prof. Dr. Rainer Thiel
Institut für Altertumswissenschaften
07737 Jena, Germany (EU)
r.thiel@uni-jena.de
next reply other threads:[~2008-09-27 7:19 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-09-27 7:19 Rainer Thiel [this message]
2008-09-27 12:19 ` adding up decimal fractions in the spreadsheet Carsten Dominik
[not found] ` <d6b6c7740809270606p679feb82n6fbe5f4d582ebcfa@mail.gmail.com>
[not found] ` <B1260157-B3E5-4704-8739-F4718BDFCAEC@uva.nl>
2008-09-27 14:20 ` Rainer Thiel
2008-09-27 17:59 ` Carsten Dominik
2008-09-27 13:21 ` Manish
2008-09-27 13:29 ` Rainer Thiel
2008-09-29 2:46 ` Manish
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=d6b6c7740809270019s5b2d6a83k7ee7cb2ad8e165ae@mail.gmail.com \
--to=r.thiel@uni-jena.de \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).