[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