[Semibug] LibreOffice is summing incorrectly

Jonathan Drews jondrews at fastmail.com
Sat May 18 22:55:44 EDT 2024


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.



More information about the Semibug mailing list