https://bugs.documentfoundation.org/show_bug.cgi?id=103532
Bug ID: 103532
Summary: SUMPRODUCT returns wrong value
Product: LibreOffice
Version: 5.1.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 128297
--> https://bugs.documentfoundation.org/attachment.cgi?id=128297&action=edit
file illustrating the bug
In the attached file, SUMPRODUCT returns wrong values.
Not only that, but the same formula returns two different values in two cells:
T19 = 20.0025562025
AE19 = 18.7191658181 (correct value)
First observed on 5.1.5, still there after upgrade to 5.1.5.
One more strange thing: if I copy formulas from AE19 to the cells below, the
formulas remain correct if I copy to less than 100 cells, but switches to the
wrong one if I copy to more than 100 cells (pass row AE118).
This happens both with copy & paste and using mouse (selecting AE19 and
dragging down).
I use Norwegian locales with comma as a decimal separator, in case it should
matter.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
