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@lists.freedesktop.org
Reporter: kelem...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs