https://bugs.documentfoundation.org/show_bug.cgi?id=108811
Bug ID: 108811
Summary: SOMME.SI / SUMIF equality tests returns wrong values -
is not the same than IF equality test - in some cases
Product: LibreOffice
Version: 5.2.7.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The equality test used in SUMIF function does not return the same value than
the IF equality test for which appears to be the same cases, resulting in
simingly wrong values.
Steps to Reproduce:
Exemple can be reproduced as follow, using the format <Cell> = "Value in cell"
:
A2 = "Aaa"
A3 = "BingoXyZ(ART)"
A4 = "Ddd"
B2 = "1"
B3 = "1"
B4 = "1"
C2 = "Aaa"
C3 = "BingoXyZ(ART)"
C4 = "Ddd"
D3 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)"
D4 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)"
D5 = "=SUMIF($A$2:$A$4;C2;$B$2:$B$4)"
E2 = "=SI(C2=A2;1;0)"
E3 = "=SI(C2=A2;1;0)"
E4 = "=SI(C2=A2;1;0)"
The goal of this exemple is to show that the label "BingoXyZ(ART)" is not being
recognized and so counted by the SUMIF function while testing equality with IF
proves that the 2 values in A3 and C3 should have been reported as the same.
Actual Results:
Value returned in SUMIF cells are :
D2 = "1"
D3 = "0"
D4 = "1"
Expected Results:
Results should have been :
D2 = "1"
D3 = "1"
D4 = "1"
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:54.0) Gecko/20100101
Firefox/54.0
--
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
