https://bugs.documentfoundation.org/show_bug.cgi?id=115642
Bug ID: 115642
Summary: SUM function in Calc gives wrong answer
Product: LibreOffice
Version: 5.3 all versions
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mich...@alzetta.org
Description:
If I open a new Calc spreadsheet, and I paste in the following numbers in a
column ( cells A1 to A6):
0,0086584
0,00159885
0,0016177
0,00164682
0,00151831
0,00155874
In cell A7 I get the correct sum if I write the formula = A1 +A2 + A3 + A4 +A5+
A6 ( 0,01659882 )
If I press the sum icon, and have A7 formula as =SOMMA(A1:A6) I get a wrong
answer ( 0,0016177 )
Steps to Reproduce:
1. Open a new Calc spreadsheet, and paste in the following numbers in a column
( cells A1 to A6):
0,0086584
0,00159885
0,0016177
0,00164682
0,00151831
0,00155874
2) Select column, and press the sum icon; A7 formula is now =SOMMA(A1:A6)
(italian version) and the total is wrong --> 0,0016177
3) In cell A7 write the formula = A1 +A2 + A3 + A4 + A5+ A6; correct answer is
given
Actual Results:
SOMMA(A1:A6) = 0,0016177
Expected Results:
SOMMA(A1:A6) = 0,01659882
Reproducible: Always
User Profile Reset: No
Additional Info:
Versione: 6.0.1.1
Build ID: Gentoo official package
Thread CPU: 8; SO: Linux 4.15; Resa interfaccia: predefinito; VCL: gtk3;
Versione locale: it-IT (it_IT.UTF-8); Calc: group
app-office/libreoffice
Installed versions: 6.0.1.1(15:14:00 10/02/2018)(bluetooth branding cups dbus
gtk java kde pdfimport -coinmp -debug -eds -firebird -googledrive -gstreamer
-gtk2 -jemalloc -libressl -mysql -odk -postgres -test -vlc ELIBC="-FreeBSD"
LIBREOFFICE_EXTENSIONS="nlpsolver -scripting-beanshell -scripting-javascript
-wiki-publisher" PYTHON_SINGLE_TARGET="python3_6 -python2_7 -python3_4
-python3_5" PYTHON_TARGETS="python2_7 python3_6 -python3_4 -python3_5")
Same problem was present with the previous version of Libreoffice
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/64.0.3282.140 Safari/537.36
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
