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
Version: 22.214.171.124 (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":
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:
Affected users are encouraged to test the fix and report feedback.