Bug Hunting Session
Bug 78614 - PIVOTTABLE: pivot table not saved in xlsx
Summary: PIVOTTABLE: pivot table not saved in xlsx
Status: CLOSED DUPLICATE of bug 89139
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.7.2 release
Hardware: Other All
: highest normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 93715 (view as bug list)
Depends on:
Blocks:
 
Reported: 2014-05-12 16:43 UTC by mwmisiek
Modified: 2015-12-01 22:53 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample file with pivot table to test saving as xlsx (13.65 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-12 22:16 UTC, m.a.riosv
Details
Sample 2: File 1 - Original/Base ODS file (20.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-09-29 19:37 UTC, Zeki Bildirici
Details
Sample 2: File 2 - File saved as xls (17.50 KB, application/vnd.ms-excel)
2014-09-29 19:38 UTC, Zeki Bildirici
Details
Sample 2: File 3 - File saved as xlsx (7.23 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-09-29 19:38 UTC, Zeki Bildirici
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mwmisiek 2014-05-12 16:43:08 UTC
Problem description: 
created pivottable is not saved properly in new M$ Office xlsx (2010) format.

Steps to reproduce:
1. open spredasheet 
2. create pivottable
3. save as xlxs (2010) and save as xls (2003)
4. close libreoffice
5. re-open xlsx - you should see pivot table is gone - there will be only table with data
6. re-open xls file - everything should work fine

Current behavior:
xlsx format is not saving pivot table data

Expected behavior:
xlsx should be saved properly with pivottable data
              
Operating System: All
Version: 4.2.4.2 rc
Comment 1 m.a.riosv 2014-05-12 22:16:29 UTC
Created attachment 98949 [details]
Sample file with pivot table to test saving as xlsx

Hi @mwmisiek, thanks for reporting.

Seem works fine saving as xls.

Sample file with a pivot table, saving as xlsx, hangs on opening with:
Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
Versión: 4.2.4.2 Id. de compilación: 63150712c6d317d27ce2db16eb94c2f3d7b699f8
Version: 4.2.5.0.0+ Build ID: c4e10ad83fe1fa92a115327c1909218f5dc8c8bd
   TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-12_10:29:35

It's possible to open saving as xlsx, but without the pivot, table only their data, with:
Version: 4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a
Version: 4.3.0.0.alpha1+ Build ID: 224b235971a01971de626d38ccc8506d0a55771b
  TinderBox: Win-x86@39, Branch:master, Time: 2014-05-11_23:55:17
Comment 2 Zeki Bildirici 2014-09-29 19:37:41 UTC
Created attachment 107086 [details]
Sample 2: File 1 - Original/Base ODS file
Comment 3 Zeki Bildirici 2014-09-29 19:38:29 UTC
Created attachment 107087 [details]
Sample 2: File 2 - File saved as xls
Comment 4 Zeki Bildirici 2014-09-29 19:38:49 UTC
Created attachment 107088 [details]
Sample 2: File 3 - File saved as xlsx
Comment 5 Zeki Bildirici 2014-09-29 19:41:41 UTC
Hi,

I can reproduce the issue with LO 4.3.0. I cannot download the first file due to an error so i've uploaded a new set of samples for test. 

Case:
- In xls version
 * Coloumn B(filter) goes inactive
 * Data(Veri) row seems active but when you right click and Refresh cells disappear and only one cell left which shows the total sum

- In xlsx version
  * Pivot table functionality disappears completely and cells behave as regular cells.

Best regards,
Zeki
Comment 6 Jim 2014-10-03 01:48:40 UTC
Looking at such issues in version 4.3.1.2

Creating a pivot table in excel, opening in calc and works.
Save from calc in xlsx and pivot table is removed by excel when opening
Save fresh copy as xls from calc and excel opens ok and filters work
Save fresh copy as xls from calc, close and open in calc, need to right click then refresh to get all filters working.
Comment 7 Björn Michaelsen 2014-12-18 10:14:05 UTC
(This is an automated message.)

Setting priority to highest as this is a MAB. This is part of an effort to make the importance of MAB reflected in priority too.
Comment 8 Marina Latini (CIB) 2015-01-15 14:01:35 UTC
Confirmed on:

* Version: 3.6.7.2 
* Build ID: e183d5b

* Version: 4.2.8.2
* Build ID: 48d50dbfc06349262c9d50868e5c1f630a573ebd

* Version: 4.3.5.2
* Build ID: 3a87456aaa6a95c63eea1c1b3201acedf0751bd5

* Version: 4.5.0.0.alpha0+
* Build ID: 84c69550bcb8139669de9cf98b51c35f21fe853d
* TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-01-13_08:44:23
* Locale: it_IT

Tests made on Ubuntu 14.04.1 LTS x86_64 with fresh user profile.
Comment 9 Buovjaga 2015-02-08 18:33:08 UTC
*** Bug 89139 has been marked as a duplicate of this bug. ***
Comment 10 Robinson Tryon (qubit) 2015-03-10 11:50:44 UTC
(In reply to Marina Latini from comment #8)
> Confirmed on:
> 
> * Version: 3.6.7.2 
> * Build ID: e183d5b

Version -> 3.6.7.2

It's possible that saving a pivot table in XLSX format has yet to be implemented. Still, as a MAB and a quick repro, it's not a bad idea to test earlier versions for completeness.
Comment 11 raal 2015-08-28 07:05:04 UTC
*** Bug 93715 has been marked as a duplicate of this bug. ***
Comment 12 Eike Rathke 2015-12-01 22:53:12 UTC
Closing as duplicate in favor of bug 89139 because that one has an original Excel .xlsx attachment for comparison.

*** This bug has been marked as a duplicate of bug 89139 ***