<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 - Autofilter dropdown behaves strangely when it's created by a macro in a specific XLSM"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=107797">107797</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Autofilter dropdown behaves strangely when it's created by a macro in a specific XLSM
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.0.alpha1+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>baron@caesar.elte.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>szymon.klos@collabora.com
</td>
</tr></table>
<p>
<div>
<pre>This is a follow-up report on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED FIXED - VBA autofilter needs support for list of strings arguments"
href="show_bug.cgi?id=107238">bug 107238</a>.
After Szymon's fix, now it's possible to run the macro (thanks!), which creates
autofilter and filters entries.
However, I noticed the autofilter selector behaves unusually after the macro.
- Open <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=132647" name="attach_132647" title="Sample XLSM">attachment 132647</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=132647&action=edit" title="Sample XLSM">[details]</a></span> in Calc.
- Run macro AF. (this should create an autofilter on columns A and B, and hide
the entry with value "D" in column A)
=> While the rows are filtered properly, the autofilter selector on column A
only shows value "A" selected (should be "A", "B" and "C"), and the icon in the
cell doesn't change to show filters are active. Filtering different entries
manually also behaves strangely.
Note that the fix to the other bug was pushed earlier today.
Version: 5.4.0.0.alpha1+
Build ID: abd619b108e697a5dd045000573d9d1bc675cc98
CPU threads: 16; OS: Linux 4.4; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc: group</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>