Description: After I import and export the attached XLS file with a pivot table in Calc and open the round tripped file in Excel the column field (Country) has no popup button in cell B3. Steps to Reproduce: 1. Open attached XLS in Calc and resave to an other XLS. 2. Open round tripped XLS in Excel Actual Results: Popup button in cell B3 is missing. Expected Results: In cell B3 Excel should display a popup button. 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/60.0.3112.113 Safari/537.36
Created attachment 136176 [details] Test document with minimal pivot table
Tamás Zolnai committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bc9714fefb2dd2ad55a92aaacb6b246f354ed2c0 tdf#112328: Pivot table, XLS: Popup button for column fields is missing 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.