A pivot field items can be calculated values (e.g. formulas) and as such it can be an errornous formula (e.g. div by zero). This error values are displayed as error strings in the pivot table. In the attached test document the row field ("b") is filtered on the "#DIV/0!" item, but LO Calc does not import this filtering.
Steps to Reproduce:
1. Open attached test document in Calc
2. Check the row field ("b") items, "#DIV/0!" should be hidden (filtered out)
Filtering is not imported.
Filtering should be imported.
User Profile Reset: No
User-Agent: Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.100 Safari/537.36
Created attachment 136778 [details]
Pivot field with a filtering of an error item
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112893: Pivot table: filtering of error item is not imported
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.