[Semibug] LibreOffice is summing incorrectly

[CAREY SCHUG]

perhaps your problem was partly because LibreOffice (and OpenOffice before) round numbers INCORRECTLY.

to a real mathematician or scientist, when rounding to tenths, both 1.15 and 1.25 round to 1.2, meaning the even number in the next position, or at least that is what I remember from college, over 50  years ago.  But Libre office ALWAYS rounds up, rounding 1.25 to 1.3. 

I'm guessing/hoping they do this because Excell also does that, but I have no way to check easily.  Now that the bug is in my ear,  perhaps I will remember to check when I go to the library on their winblows computers, or maybe somebody will report here.

Or maybe there is a setting in LibreOffice to correct this?

<pre>--Carey</pre>

> On 05/18/2024 9:55 PM CDT Jonathan Drews <jondrews at fastmail.com> wrote:
> 
>  
> On Sat, May 18, 2024 at 06:44:51PM -0600, Jonathan Drews wrote:
> > I got a big problem. If I sum the column of numbers in LibreOffice Iget
> > 43.81000
> > 0.00000
> > 95.53000
> > 21.90000
> > 18.90000
> > 37.72000
> > 174.89000
> > 16.73000
> > 0.00000
> > 18.56000
> > 0.00000
> > 
> > 423.02067
> > 
> > or rounded to two places 423.02
> 
> The original spreadsheet was using numbers from a diviison. I solved
> the problem by summing over number that were properly rounded using
> =ROUND(number, decimal places). I then  get the correct answer.
> 
> Thanks Ron.
> 
> _______________________________________________
> Semibug mailing list
> Semibug at lists.nycbug.org
> https://lists.nycbug.org:8443/mailman/listinfo/semibug