An Excel spreadsheet with a Pivot table where the Page Fields are filtered are saved with the filter active. See https://picasaweb.google.com/lh/photo/uQNvuoAiWHsV301LuHua1srAtOZmV-Q5sojAXQmA7B0?feat=directlink When this file is opened with LibreOffice (or OpenOffice.org) the filter is showing wrong, see https://picasaweb.google.com/lh/photo/B0Q4cp0BsXPwqRZCNWWd68rAtOZmV-Q5sojAXQmA7B0?feat=directlink What in Excel wasn't selected as filter is in LibreOffice removed from the filter list. If I start the pivot and look at the options for the Page Field, I can see that the "Hide items" are filled out with everything not selected in the original pivot page field. https://picasaweb.google.com/lh/photo/FS_gIr5jOIZ85C3HTw9XE8rAtOZmV-Q5sojAXQmA7B0?feat=directlink It seems that the 'filter' in XLSX is translated into 'hide' during import. This is the case with all LibreOffice versions and OOo. Its a problem on Linux and Windows. If the spreadsheet is saved as xls in Excel it works fine.
XLSX import is Muthu's realm.
@Leif: Could you please provide the sample document please? is this xls or xlsx? Thank you.
Created attachment 46139 [details] Example
@Muthu Sorry about the late response. I have attached an example document. It seems only a problem in xlsx and *not* in binary xls. I tried to create a simple spreadsheet with a simple pivot. It doesn't give me any problems.
In 3.4 beta 3 the document can't even open.
Bug still occurs under LO 3.6.0.4
Tested in LO Version: 4.3.0.0.beta2 Build ID: a06aa316117a6ff0f05c697c82831c227812d810 Bug doesn't occurs. When I open attachment in Calc, I can see all filter items with two items selected - NO, HU.
The unselected as filter items are no longer removed from the filter list in LO 4.2.x and newer. Marking as fixed.