<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:stephane.guillou@member.fsf.org" title="stragu <stephane.guillou@member.fsf.org>"> <span class="fn">stragu</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - AutoFilter dropdown is lost when range has no header and the first value is filtered out"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118625">bug 118625</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>AutoFilter is lost when selecting blank values with no header
</td>
<td>AutoFilter dropdown is lost when range has no header and the first value is filtered out
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>stephane.guillou@member.fsf.org
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - AutoFilter dropdown is lost when range has no header and the first value is filtered out"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118625#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - AutoFilter dropdown is lost when range has no header and the first value is filtered out"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=118625">bug 118625</a>
from <span class="vcard"><a class="email" href="mailto:stephane.guillou@member.fsf.org" title="stragu <stephane.guillou@member.fsf.org>"> <span class="fn">stragu</span></a>
</span></b>
<pre>Reproduced with:
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: de7356c2e0cb099fac396808b5a86a0393b48e5f
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time:
2021-06-14_22:38:17
Calc: threaded
Changing title as it is not required to select a blank value to reproduce.
Steps:
1. Fill a range with numbers in a single column
2. Select said range
3. Data > AutoFilter
4. Answer "No" when asked about using the first line as a header
5. Click the AutoFilter dropdown, deselect the first value, click "OK"
Result: the AutoFilter dropdown disappears.
I'm wondering what would be a preferred solution:
- Always enforce headers for AutoFilter? or
- Move autofilter dropdown menu to the first visible cell in the AutoFilter
range? (Which means you end up with an AutoFilter dropdown menu that is
technically below the top of the range.)</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>