Bug 81999 - FILEOPEN: XLSX: self-contained filtered pivot table. Lost pivot table.
Summary: FILEOPEN: XLSX: self-contained filtered pivot table. Lost pivot table.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
Reported: 2014-08-01 07:46 UTC by raal
Modified: 2022-05-02 22:01 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

test file (11.26 KB, application/vnd.openxmlformats-officedocument.spreadsheetml)
2014-08-01 07:46 UTC, raal
printscreen from ms office (6.15 KB, image/png)
2014-08-06 07:01 UTC, raal

Note You need to log in before you can comment on or make changes to this bug.
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. 

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 - 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 Buovjaga 2014-11-12 13:08:37 UTC
Unable to locate pivot table -> NEW.

Win 7 64-bit Version:
Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827
TinderBox: Win-x86@42, Branch:master, Time: 2014-11-12_00:19:18
Comment 6 QA Administrators 2016-01-17 20:03:02 UTC Comment hidden (obsolete)
Comment 7 eisa01 2018-06-16 18:22:58 UTC
Still present

Build ID: b292a27698e85fd9d60c03613c3b0c67835c4dc1
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-06-06_23:25:55
Locale: en-US (en_US.UTF-8); Calc: group threaded
Comment 8 Roman Kuznetsov 2019-05-04 15:14:10 UTC
still repro in

Version: (x64)
Build ID: 7ca7d61dc25f409e209b3a432c7f07469b17e316
CPU threads: 4; OS: Windows 6.1; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-05-03_23:08:41
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: CL