<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 - Filter displays wrong rows"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122975">122975</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Filter displays wrong rows
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.4.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>roger.millichamp@virgin.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
If I filter a column to only display non empty rows then rows that are empty
are displayed.
Steps to Reproduce:
1.In a new spreadsheet:
a) column A: put a value in rows 1 to 3
b) Column B: put a value in row 2
2. Apply a filter:
a) Select the whole of Column B by selecting the column label
b) Select the menu item Data-> More Filters -> Standard Filter which opens
the standard filter dialogue
c) The selection in Column B will now change to select only rows 1 and 2.
This is not correct
d) In the dialogue set Column B: Condition: =, Value: Not Empty, and then
OK
3.
Actual Results:
Rows 2 and 3 will be displayed
Expected Results:
1) In step 2c either the whole of Column B should remain selected on rows 1 to
3 should be selected
2) In the final result only row 2 should be displayed as that is the only rows
in Column B that has a value
Reproducible: Always
User Profile Reset: Yes
Additional Info:
The above is not correct behaviour because the user will expect the filter to
be applied to what the user selected and will not expect Calc to modify the
selection.
Fix: The filter should be applied to the rows in Column B that have a value in
ANY column rather than just those that have a value in Column B.
Version: 6.1.4.2 (x64)
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: en-GB (en_GB); Calc: CL</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>