A pivot table field can have empty fields which are displayes as "(empty)" string on table layout (e.g. row and column fields). However when we add a filtering to a page field which contains only the empty item, then the page field shows only an empty cell, instead of displaying "(empty)" string.
Steps to Reproduce:
1. Open attched test document in Calc
2. Refresh pivot table
After refresh page field becomes empty.
After refressh "(empty)" string should be added to the page field cell.
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 136598 [details]
A pivot table with a page field fitlered to have only the "(empty)" item selected
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112735: Pivot table: page field displays empty string
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.