<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - SOMME.SI / SUMIF equality tests returns wrong values - is not the same than IF equality test - in some cases"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108811">108811</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>SOMME.SI / SUMIF equality tests returns wrong values - is not the same than IF equality test - in some cases
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>david.lacorre@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>