<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 - XLSX FILEOPEN: Autofiltered date column and another filtered column discard the filtering"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116818">116818</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>XLSX FILEOPEN: Autofiltered date column and another filtered column discard the filtering
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>Keywords</th>
<td>filter:xlsx
</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>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=141122" name="attach_141122" title="Example file from Excel 2010">attachment 141122</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=141122&action=edit" title="Example file from Excel 2010">[details]</a></span>
Example file from Excel 2010
Attached XLSX file from Excel 2010 has a Date type column, a text format and a
number format column with auto-filter, set to filter out some date from the
first column and filter out some text from the second column. Opening the
attached file with LibreOffice Calc, the filter list has disappeared in the
second and third (text/number) column.
Steps to reproduce:
1. Create a new spreadsheet with Microsoft Excel 2010/2013/2016
2. Set the first column cells format to Date type, the second/third one to
text/number
3. Fill the three column with some data. Optional: (the date column should
contain at least three different year)
4. Set an autofilter to the three columns, and filter out some year from the
date column and filter out something from the second or third column
5. Save the file as *.XLSX and open with LibreOffice Calc
6. Save as the *.XLSX file with LibreOffice Calc and reload the file
Actual results:
After we import the *.XLSX file, the second and third filter list disappeared.
The date filter list was just wrong
After we export the *.XLSX file, the filters disappeared from the first row,
but the _xlmn._FilterDatabase named range was good.
Expected results:
The combined filtering should work fine, even if we filter date type column and
another ones together.
Version: 6.0.4.0.0+
Build ID: 30db8c9b1d9654e62c11657140fac24f0f52c547
CPU threads: 4; OS: Windows 6.1; UI render: default;
TinderBox: Win-x86@42, Branch:libreoffice-6-0, Time: 2018-03-27_01:00:13
Locale: hu-HU (hu_HU); 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>