Description: 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 Actual Results: In G6 cell of the pivot table the "(empty)" value is displayed. Expected Results: In G6 cell of the pivot table the "#DIV/0!" string should be displayed. 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 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=ee46269003aed237edcd9c086fd14ecded08bbeb 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/3e7e6f6fc7f8f03c6ba329c547749e3f3746c2a0 tdf#112884: sc_uicalc: Add unittest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
For the record: this was a regression from https://cgit.freedesktop.org/libreoffice/core/commit/?id=d4cd8677889ec3807c194ef5b462f8e031807e5b