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
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
Created attachment 107086 [details] Sample 2: File 1 - Original/Base ODS file
Created attachment 107087 [details] Sample 2: File 2 - File saved as xls
Created attachment 107088 [details] Sample 2: File 3 - File saved as xlsx
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
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.
(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.
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.
*** Bug 89139 has been marked as a duplicate of this bug. ***
(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.
*** Bug 93715 has been marked as a duplicate of this bug. ***
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 ***