Bug 35414

Summary:	Problem with Pivot from xlsx when filtered by Page Fields
Product:	LibreOffice	Reporter:	Leif Lodahl <leiflodahl>
Component:	Calc	Assignee:	Muthu <muthu.subramanian.karunanidhi>
Status:	RESOLVED FIXED
Severity:	normal	CC:	hhielscher, raal
Priority:	medium
Version:	unspecified
Hardware:	x86 (IA32)
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Example

Description Leif Lodahl 2011-03-18 04:33:27 UTC

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.

Comment 1 Kohei Yoshida 2011-03-21 19:31:04 UTC

XLSX import is Muthu's realm.

Comment 2 Muthu 2011-04-13 09:45:50 UTC

@Leif: Could you please provide the sample document please? is this xls or xlsx?
Thank you.

Comment 3 Leif Lodahl 2011-04-28 07:34:31 UTC

Created attachment 46139 [details]
Example

Comment 4 Leif Lodahl 2011-04-28 07:39:46 UTC

@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.

Comment 5 Leif Lodahl 2011-04-29 05:25:09 UTC

In 3.4 beta 3 the document can't even open.

Comment 6 Pedro 2012-08-14 13:44:04 UTC

Bug still occurs under LO 3.6.0.4

Comment 7 raal 2014-06-08 08:49:36 UTC

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.

Comment 8 Luke 2014-08-30 15:23:18 UTC

The unselected as filter items are no longer removed from the filter list in LO 4.2.x and newer. Marking as fixed.