Created attachment 133170 [details] Example file made in Excel 2013 Attached file was made with Excel 2013 and has a pivot table page field (named pwdLastSet) which is filtered to show only date values from 2017. In current master Calc it hides only the empty cells, and not the ones with values 2014 and 2016.
Created attachment 133171 [details] The empty and < 2017 values are filtered out in Excel
Created attachment 133173 [details] Only the empty values are filtered out in Calc
Reproducible. Version: 5.3.3.2 (x64) Build ID: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; Locale: es-ES (es_ES); Calc: group Even with LibreOffice, selected dates are not preserved saving on xlsx format, but works with ods.
Created attachment 136348 [details] Pivot table page fields filter is working correctly with .XLS format
Bartosz, are you still working on this issue?
Tamás Zolnai committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=625653c8d119e720fb93b0c9f6f50d1eb625b179 tdf#107711:Pivot table: filtering of non-string fields is not exported to XLSX It will be available in 6.0.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.