From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <dominik@uva.nl>
Subject: Re: decimal fractions when summing up large numbers
Date: Wed, 24 Sep 2008 17:38:59 +0200
Message-ID: <1EB2649A-3D01-4F94-982F-B6DD2718C467@uva.nl>
References: <d6b6c7740809240815t2987d251sc28cedba57409ff7@mail.gmail.com>
Mime-Version: 1.0 (Apple Message framework v929.2)
Content-Type: text/plain; charset=ISO-8859-1; format=flowed; delsp=yes
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1KiWSO-0003bp-KF
	for emacs-orgmode@gnu.org; Wed, 24 Sep 2008 11:39:12 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1KiWSL-0003Y1-Dd
	for emacs-orgmode@gnu.org; Wed, 24 Sep 2008 11:39:11 -0400
Received: from [199.232.76.173] (port=43534 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1KiWSK-0003XR-JJ
	for emacs-orgmode@gnu.org; Wed, 24 Sep 2008 11:39:09 -0400
Received: from paard.ic.uva.nl ([145.18.40.182]:41806)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <dominik@uva.nl>) id 1KiWSI-0007eT-Mj
	for emacs-orgmode@gnu.org; Wed, 24 Sep 2008 11:39:07 -0400
In-Reply-To: <d6b6c7740809240815t2987d251sc28cedba57409ff7@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: r.thiel@uni-jena.de
Cc: emacs-orgmode <emacs-orgmode@gnu.org>

Hi Rainer,

turns out, org-table-sum is an old function I have not looked at for a =20=

long time.  It used (format "%g" res) to format the final result for =20
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 =20=

> section.
>
> Many thanks in advance
>
> Rainer
> --=20
> Prof. Dr. Rainer Thiel
> Institut f=FCr 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