<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 - PIVOTTABLE: empty values filtering works incorrectly for Date type columns"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108834">108834</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>PIVOTTABLE: empty values filtering works incorrectly for Date type columns
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.0.beta2
</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>kelemeng@ubuntu.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134343" name="attach_134343" title="Sample file">attachment 134343</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134343&action=edit" title="Sample file">[details]</a></span>
Sample file
Attached spreadsheet contains a simple pivot table with a filter in B1 set to
show only the empty values.
The number of values shown after filtering differs from the ones I'd expect.
Of the "Second type" (cell A5) there should be 5 entries on the users sheet,
yet Calc shows the value 9 in cell B5.
Clicking on the cell produces a new sheet with the 9 "Second type" rows, of
which 4 have a value in the filtered pwdLastSet column.
Similarly for the hidden (empty) type in cell A6 Calc should show 2 in B6, yet
it shows 3.
Autofiltering the C and E columns on the users sheet shows correct number of
"Second type" and (empty) values where the E column is empty: 5 and 2.</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>