Re: decimal fractions when summing up large numbers

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