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 <jondr...@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@lists.nycbug.org > https://lists.nycbug.org:8443/mailman/listinfo/semibug _______________________________________________ Semibug mailing list Semibug@lists.nycbug.org https://lists.nycbug.org:8443/mailman/listinfo/semibug
