<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN XLSX Autofilter opened incorrectly with more than 8 filtering conditions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=140469#c5">Comment # 5</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILEOPEN XLSX Autofilter opened incorrectly with more than 8 filtering conditions"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=140469">bug 140469</a>
from <span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=169817" name="attach_169817" title="Another example file with filtered date column">attachment 169817</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=169817&action=edit" title="Another example file with filtered date column">[details]</a></span>
Another example file with filtered date column
This is <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> from <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - XLSX FILEOPEN: Autofiltered date column and another filtered column discard the filtering"
href="show_bug.cgi?id=116818">bug #116818</a> saved with current Calc master.
Here the filtering condition changes in the XML (but works the same in Excel),
from:
<filterColumn colId="0">
<filters>
<dateGroupItem year="2014" dateTimeGrouping="year"/>
<dateGroupItem year="2012" dateTimeGrouping="year"/>
</filters>
</filterColumn>
changes is Calc export to:
<filterColumn colId="0">
<filters>
<dateGroupItem year="2014" month="12" day="12" dateTimeGrouping="day"/>
<dateGroupItem year="2014" month="12" day="13" dateTimeGrouping="day"/>
<dateGroupItem year="2014" month="12" day="14" dateTimeGrouping="day"/>
<dateGroupItem year="2014" month="12" day="15" dateTimeGrouping="day"/>
<dateGroupItem year="2014" month="12" day="16" dateTimeGrouping="day"/>
<dateGroupItem year="2014" month="12" day="17" dateTimeGrouping="day"/>
<dateGroupItem year="2012" month="12" day="02" dateTimeGrouping="day"/>
<dateGroupItem year="2012" month="12" day="03" dateTimeGrouping="day"/>
<dateGroupItem year="2012" month="12" day="04" dateTimeGrouping="day"/>
<dateGroupItem year="2012" month="12" day="05" dateTimeGrouping="day"/>
<dateGroupItem year="2012" month="12" day="06" dateTimeGrouping="day"/>
</filters>
</filterColumn>
This puts it above the 8 conditions limit and fails to display in Calc.</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>