<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 - EDITING Selecting filtered cells with hidden rows in between causes a bug in filter reset."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124093">124093</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING Selecting filtered cells with hidden rows in between causes a bug in filter reset.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 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>j.ragan@ms.pl
</td>
</tr></table>
<p>
<div>
<pre>Description:
When column or range is filtered by some criteria and in result some rows are
hidden, there is a potential to trigger a bug in filter reset function. To
trigger it, the user has to make a partial selection with hidden rows in
between. If the user decides to reset the filter with his selection still
active (or being the last selection in that column), then using reset filter
option will reset only the last selection, leaving some rows still hidden (with
filter applied, selecting rows and pressing delete removes content only from
visible cells).
To fix the sheet, the user has to apply any standard filter and reset it
without making selection.
Steps to Reproduce:
1.Select a column or columns to filter out the duplicates
2.Set criteria for filter (non empty + no duplication will work best in the
provided file)
3.Make your own selection in the filtered range (but don't select cells outside
filter range)
4.Reset filter
Actual Results:
Cells outside user selection still have filter applied.
Expected Results:
Reset filter should completely remove applied filter from active sheet.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
This bug causes loss of ability to add columns on left or right from context
menu (try adding columns with context menu on Sheet2), and also causes loss of
ability to paste multi row selection from other sheets if there is a collision
with hidden rows (try copying rows from Sheet1 to Sheet2).
The result of this bug is saved to the file, please see Sheet2
The bug has been reproduced in the following builds:
3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4
4.0.0.1 (Build ID: 527dba6f6e0cfbbc71bd6e7b88a52699bb48799)
5.4.7.2 (x64) Build ID: c838ef25c16710f8838b1faec480ebba495259d0
6.1.1.2 (x64) Build ID: 5d19a1bfa650b796764388cd8b33a5af1f5baa1b
6.3.0.0.alpha0+ (x64) Build ID: 91cdf22b88a4f7bec243c8fb187627e766d3294c</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>