<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 - FILEOPEN XLSX Autofilter does not check values ending with zeroes"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=142215">142215</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILEOPEN XLSX Autofilter does not check values ending with zeroes
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.2.0.0.alpha0+ 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>Keywords</th>
<td>filter:xlsx, implementationError
</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>libreoffice@nisz.hu
</td>
</tr>
<tr>
<th>CC</th>
<td>nemeth@numbertext.org, varga.balazs3@nisz.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>123807
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=171873" name="attach_171873" title="Screenshot of the original document in Excel">attachment 171873</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=171873&action=edit" title="Screenshot of the original document in Excel">[details]</a></span>
Screenshot of the original document in Excel
This is a followup to <a class="bz_bug_link
bz_status_VERIFIED bz_closed"
title="VERIFIED FIXED - FILEOPEN XLSX Autofilter does not take number formatting in account"
href="show_bug.cgi?id=140968">bug 140968</a>
<span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=170421" name="attach_170421" title="Example file from Excel">attachment 170421</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=170421&action=edit" title="Example file from Excel">[details]</a></span> contains some fractional values that are filtered to be
displayed.
In Calc the ones ending with zeroes do appear as visible on the sheet, but they
are not checked in the autofilter dropdown.
Steps to reproduce:
1. Open <span class=""><a href="https://bugs.documentfoundation.org/attachment.cgi?id=170421" name="attach_170421" title="Example file from Excel">attachment 170421</a> <a href="https://bugs.documentfoundation.org/attachment.cgi?id=170421&action=edit" title="Example file from Excel">[details]</a></span>
2. Open the autofilter dropdown on column A
Actual results:
4,00 and 12,60 are not checked.
Expected results:
4,00 and 12,60 should be checked in the autofilter.
LibreOffice details:
Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: d7f734db2c078ced3ce08ad58cd816a79abe3bcf
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] XLSX Autofilter-related bugs"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123807">Bug 123807</a>] [META] XLSX Autofilter-related bugs
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>