<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 - Autofilter is confuse cells with similar numbers"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107917">107917</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Autofilter is confuse cells with similar numbers
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>motta.tiago@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
The command AUTOFILTER does not distinct differences between cells in
spreadsheet Calc that contains similar numbers such as -1 and 1 OR 1 and 100.
The spreadsheet does not filter correctly the rows containing the cells
corresponding your query.
Steps to Reproduce:
1. enable autofilter command
2. choice a value with contains numbers similars (e.g. 1 and 100)
3. do
Actual Results:
After I enable autofilter command, I try to filter the rows containing "1" as
value. In this moment, I expect that only rows containing "1" in the column
filtered were showing.
Expected Results:
Any lines containing "1" contained in the cells and filtered lines "100" as the
value was shown.
Reproducible: Always
User Profile Reset: Yes, I try clear my user profile. About the question above
(What should the software have done instead?), the spreadsheet should filter
rows and exhibits only rows with cells corresponding to parameter value.
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
Firefox/45.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>