From: Carsten Dominik <dominik@uva.nl>
To: r.thiel@uni-jena.de
Cc: emacs-orgmode <emacs-orgmode@gnu.org>
Subject: Re: decimal fractions when summing up large numbers
Date: Wed, 24 Sep 2008 17:38:59 +0200 [thread overview]
Message-ID: <1EB2649A-3D01-4F94-982F-B6DD2718C467@uva.nl> (raw)
In-Reply-To: <d6b6c7740809240815t2987d251sc28cedba57409ff7@mail.gmail.com>
Hi Rainer,
turns out, org-table-sum is an old function I have not looked at for a
long time. It used (format "%g" res) to format the final result for
display - bad idea indeed, because that causes the unwanted rounding.
I have removed this, the change has just been pushed to the git repo.
Thanks for the report.
- Carsten
On Sep 24, 2008, at 5:15 PM, Rainer Thiel wrote:
> I have a problem I am confident there is a solution to. I even
> suspect it may be explained in the manual, but can't for the life of
> me find it:
>
> Summing up small numbers in tables isn't a problem even when they have
> digits after the decimal point. For example, org-table-sum applied on
> the table
>
> | 10000.7 |
> | 10000.5 |
> | 10000.3 |
>
> correctly gives 30001.5. On the other hand, applied on the table
>
> | 100000.7 |
> | 100000.5 |
> | 100000.3 |
>
> org-table-sum gives 300002, the correctly rounded value of 300001.5,
> which would be the exact value.
>
> How can I make org-table-sum deliver the exact value?
>
> If this is explained in the manual, please point me to the relevant
> section.
>
> Many thanks in advance
>
> Rainer
> --
> Prof. Dr. Rainer Thiel
> Institut für Altertumswissenschaften
> 07737 Jena, Germany (EU)
> r.thiel@uni-jena.de
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
next prev parent reply other threads:[~2008-09-24 15:39 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2008-09-24 15:15 decimal fractions when summing up large numbers Rainer Thiel
2008-09-24 15:38 ` Carsten Dominik [this message]
2008-09-24 15:49 ` Bernt Hansen
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
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=1EB2649A-3D01-4F94-982F-B6DD2718C467@uva.nl \
--to=dominik@uva.nl \
--cc=emacs-orgmode@gnu.org \
--cc=r.thiel@uni-jena.de \
/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 external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.