Bug 81999

Summary:	FILEOPEN: XLSX: self-contained filtered pivot table. Lost pivot table.
Product:	LibreOffice	Reporter:	raal <raal>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	marina, suokunlong, todventtu
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=79332
Whiteboard:
i915 platform:		i915 features:
Attachments:	test file printscreen from ms office

Description raal 2014-08-01 07:46:19 UTC

Created attachment 103796 [details]
test file

From bug 79332.
When pivot table contains Report filter, then open this file is broken.

Steps to reproduce:
open attached file

Actual results
Pivot table broken - lost buttons

expected results
Functional pivot table

Comment 1 Kevin Suo 2014-08-01 16:57:36 UTC

Hi, please have a look at bug 58691, is your bug a dublicate of that one?

Bug 58691 is regarding export  spreadsheet which contains pivot table to XLSX. When save as XLSX, pivot table bocomes plain text.

If not a duplicate, please explain how your test xlsx file was generated. 

Thanks!

Comment 2 raal 2014-08-01 18:41:58 UTC

Xlsx file was created in Excel 2010:
- new file, fill some data
- create pivot table on second sheet
- delete source sheet ; pivot table now use cached data
- filter data in pivot table
- save file

open file in LO, pivot table lost.

Comment 3 ign_christian 2014-08-02 15:43:33 UTC

(In reply to comment #0)
> Created attachment 103796 [details]
> test file
I can't confirm with MSO, but with Kingsoft 2013 that pivot table exist.
Not exist in LO 4.2.6.2 - Ubuntu 12.04 x86

@Kevin, I think we should separate this import issue with export issue in Bug 58691 until a dev confirm those have same root.

Comment 4 raal 2014-08-06 07:01:34 UTC

Created attachment 104128 [details]
printscreen from ms office

Comment 5 Beluga 2014-11-12 13:08:37 UTC

Unable to locate pivot table -> NEW.

Win 7 64-bit Version: 4.4.0.0.alpha2+
Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827
TinderBox: Win-x86@42, Branch:master, Time: 2014-11-12_00:19:18

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.