Page field filtering is a bit different compared to other fields (row, column). When only one item is selected the page field combobox cell shows this selected entry. It seems LO's XLS import does not handle this kind of filtering well. When I open such a document with LO Calc, all item are selected of the page field, not the one which was selected in Excel.
Steps to Reproduce:
1. Open attached XLS in LO
2. Compare the page field selected items to MSO Excel
All items are selected.
Only one item should be selected ("Banana")
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 136198 [details]
Simple pivit table with one page field
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#112348: Pivot table: page field filtering is not imported from XLS
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.