[Semibug] LibreOffice is summing incorrectly

Jonathan Drews jondrews at fastmail.com
Sat May 18 20:44:51 EDT 2024


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

But if I add them up using dc then I get the correct answer:

$ dc
2 k
43.81 95.53 21.90 18.90 37.72 174.89 16.73 13.56 + + + + + + + p
423.04

I am using  LibreOffice 24.2.1.2 420(Build:2) on

OpenBSD 7.5 GENERIC.MP#82 amd64

I have searched the web there are problems with LibreOffice SUM. I also
added the numbers up in LibreOffice like so:

=43.81+ 95.53+ 21.90+ ...  and I still get 423.02. 

Any insight into what's happening would be appreciated. 

I discovered this problem when I was using GnuCash. Gnucash gives the
correct sums but LibreOffice does not.

--
Kind regards,
Jonathan
 



More information about the Semibug mailing list