https://bugs.documentfoundation.org/show_bug.cgi?id=106478
Bug ID: 106478
Summary: wrong calculation of function "summenprodukt" in
combination with "teilergebnis"
Product: LibreOffice
Version: 5.2.5.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: weikelmann.fr...@gmail.com
Description:
Calculate amount of "x" in a column.
“x” is a result of a function “WENN”
Use “=SUMMENPRODUKT(TEILERGEBNIS(3;INDIREKT("B"&ZEILE(3:12)))*(B3:B12="x"))“
doing the calculation.
Calc get the result „50“; Excel 2016 get the result “5” (correct) using same
input values and functions.
See attached files for reference.
Steps to Reproduce:
Use attached file.
Actual Results:
50
Expected Results:
5
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/56.0.2924.87 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