I found this issue only on master, so must a recent regression. If I create a pivot table which has some error cells in its source range, then the error strings are not displayed in the pivot table layout. They are replaced with the "(empty)" string.
I can't reproduce the same issue on libreoffice-5-4 branch.
Steps to Reproduce:
1. Open attached ODS with a simple pivot table
2. Refresh the pivot table
In G6 cell of the pivot table the "(empty)" value is displayed.
In G6 cell of the pivot table the "#DIV/0!" string should be displayed.
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 136767 [details]
Simple pivot table with an error item
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112884: Error string is displayed as empty item in pivot table
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.