<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 - Auto Filter Columns are Treated Separately in the Attached ODS File"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113585">113585</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Auto Filter Columns are Treated Separately in the Attached ODS File
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (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>suokunlong@126.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=137436" name="attach_137436" title="test ods file">attachment 137436</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=137436&action=edit" title="test ods file">[details]</a></span>
test ods file
The attached .ods file has two columns of data. In the most recent libreoffice
version, these two columns are treated separately when doing auto-filtering.
Steps to Reproduce:
1. Click on the drop-down list to filter-out "201607" in column B.
2. Click on the drop-down list to observe the items as shown in the filter-list
in column A.
Current Behaviour:
In step 2, all the items are shown in the filtered list.
Expected Behaviour:
Only 07-2016 is shown in step 2.
Further Information:
Apparently Calc is treating these two columns as separate data:
* If you select cell B1, click the autofilter toolbar icon to remove the
autofilter status, only autofilter for column A is removed. It should remove
both.
* If you select A1:B3692, then click the autofilter toolbar icon to remove the
autofilter, then filter on both columns are removed, but if you click the icon
to set autofilter again, then filter is set separately again.
The ods file was generated using LibreOffice, I am not sure which version was
used to create this file.</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>