<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 - CALC AutoFilter Top 10 malfunctions when another column is already filtered"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=138438">138438</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CALC AutoFilter Top 10 malfunctions when another column is already filtered
</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>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>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When an array column has been filtered to exclude a number of specific entries
the selection of "top 10" in any other column's filter returns an empty array.
When the recalcitrent filter is then amended to select "all" it remains empty -
the "all" selection is simply ignored.
Choosing "Not Empty" then re-establishes a positive array which can be further
manipulated. "All" can then be selected and functions as expected.
Steps to Reproduce:
Sample File "Filter Error" attached
Column B has already been filtered to sort inverted and column C has been
filtered to exclude the final 6 days of November.
1 Filter column J "Top Ten" - observe the effect
2 Filter column J "All" - observe the effect
3 Filter column J "Not Empty" - observe the effect
4 Filter column C "All" - observe the effect
5 Repeat steps 1 & 2 - observe the effect
Note: The division by zero error in K3 & L3 is obviously anticipated
Actual Results:
Entire array disappears
Expected Results:
Top 10 filter
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
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>