[Libreoffice-bugs] [Bug 108834] New: PIVOTTABLE: empty values filtering works incorrectly for Date type columns

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108834

            Bug ID: 108834
           Summary: PIVOTTABLE: empty values filtering works incorrectly
                    for Date type columns
           Product: LibreOffice
           Version: 5.4.0.0.beta2
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kelemeng at ubuntu.com

Created attachment 134343
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134343&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170628/da7eeb50/attachment.html>