Description: 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) Actual Results: Filtering is not imported. Expected Results: Filtering should be imported. Reproducible: Always User Profile Reset: No Additional Info: 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9fa34e9f2cebe2cfc551668f2a67ddcb799d3fb8 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.