[Libreoffice-bugs] [Bug 108811] New: SOMME.SI / SUMIF equality tests returns wrong values - is not the same than IF equality test - in some cases

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: david.lacorre at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170627/8353d1b0/attachment-0001.html>