<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 - MATCH works only partially"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138910">138910</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>MATCH works only partially
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.3.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>a.skembris@quantdata.gr
</td>
</tr></table>
<p>
<div>
<pre>Description:
MATCH seems to work properly for some stings but not for others.
In the attached file, in column H there are MATCH commands for the strings in
column C. Only some strings are found.
This is not due to improper typing of the strings. MATCH finds the same values
even when the strings are retrieved using an indirect reference, so no typing
is involved. To test this, you can change the value in cell E2 from 1 to 5.
Values 1-3 are matched, values 4 and 5 are not, just like the manual version of
column H.
By the way, saving the spreadsheet and opening it in Excel 2010 (through Wine)
gives a different set of weird results. In that case, MATCH returns wrong
results for the first cases, correct results for the second two cases, and case
5 also fails.
Steps to Reproduce:
1. Open example file
2. Change cell E2 from 1 to 5
Actual Results:
For E2 values 1-3, MATCH works correctly, for values 4-5 MATCH fails.
Expected Results:
Correct results should be returned in all cases.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: kf5
Locale: en-GB (en_US.UTF-8); UI: en-US
Calc: threaded</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>