Description: 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 Actual Results: All items are selected. Expected Results: Only one item should be selected ("Banana") 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 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": http://cgit.freedesktop.org/libreoffice/core/commit/?id=55a43f30a54816e13eb6704a8ec5952a63b01a64 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: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.