<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 - UI Autofilter on date cells: Filter result doesn't correspond to user input, user input is modified automatically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=112258">112258</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>UI Autofilter on date cells: Filter result doesn't correspond to user input, user input is modified automatically
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</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>Stefan_Lange_KA@T-Online.de
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=136074" name="attach_136074" title="spreadsheet to demonstrate the behavior">attachment 136074</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=136074&action=edit" title="spreadsheet to demonstrate the behavior">[details]</a></span>
spreadsheet to demonstrate the behavior
When in a sheet with date cells autofilter is set, the filter results do not
correspand the selected filter criteria.
Furthermore the filter function needs quite many time and - very bad - the
filter criteria entered by the user are "automatically" changed while filter
works.
Steps to reproduce:
- open the attached small spreadsheet "Test_Autofilter_Date.ods"
Step 1:
- click on the autofilter arrow in column A ("Datum"), unselect "All" and
select one or more years -> presss OK
Result:
- expected: only rows with date in selected years are filtered
- actually: Not only the selectd years are filtered, but all rows except the
empty rows
Remark: In other cases not all rows are selected
Step 2:
- click on the autofilter arrow in column a again
Result:
- expected: only the years selected in Step 1 are selected in the filter list
- actually: all years except "empty" are selected in the filter list (this
corresponds to the filter result from Step 1)
Remark: In other cases (most of my own spreadsheets) not all years are
automatically selected in the filter list by filter function, but nearly never
the selection entered by the user is kept.
The bug was reproduced with LO 5.4.0, LO 5.4.1 and LO 6.0.0.0.alpha0. In LO
5.3.5 the autofilter on date cells works properly.</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>