In MSO Excel there are more layout mode for pivot tables. In the attached test document the first pivot table has compact mode, which mode is not supported by LO Calc. This bug report is not about adding support for this mode, but at least avoid to add dummy popup buttons to wrong places.
Steps to Reproduce:
1. Open attached document in LO
2. Check first pivot table popup buttons
3. Two buttons are placed to wrong place (see screenshot)
Popupbuttons are placed to wrong cells after import (it is solved by refresh).
Popupbuttons should placed to the same cells where MSO displays them.
User Profile Reset: No
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 136380 [details]
Pivot table using different modes
Created attachment 136381 [details]
Screenshot showing the actual result
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112501: Pivot table: popupbuttons are placed on wrong cells
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.