Description: I am creating a pivot table with LibreOffice calc 6.1 in linux and try to save as to 'Excel 2007-2019(.xlsx)' to create an .xlsx file to open in window machine with MS office 2016/2010. When i open the same .xlsx file window machine then i can see only the text data in pivot sheet.all pivot functionality has been lost but same file working good in linux machine where it created. Steps to Reproduce: 1.Create pivot table with libreoffice calc in linux machine 2. Saveas to .xlsx file with filter 'Excel 2007-2019' 3. working good 4. Transfer the same .xlsx file to windows machine 5. open the same .xlsx file in windows machine with ms office 2016 Actual Results: I can see only the text data in pivot sheet and all pivot functionality moved out. Expected Results: all pivot functionality moved should be there in windows machine Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info:
Created attachment 148977 [details] atached the xlxs file created in lunix machine
please attach source ODS file
(In reply to Roman Kuznetsov from comment #2) > please attach source ODS file I'm sorry. You direct save file to XLSX from LibreOffice without creating of ODS file, right?
yes we can save the file directly xlsx in linux machine with LibreOffice but my problem is that the pivot functionality is not working in windows machine with MS office.
Can you confirm if the xlsx file created with pivot table in Linux machine can be opened in MS office (Windows Machine) without any lost of pivot functionality. Please let me know the process.
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone else confirms it.
Created attachment 149242 [details] test pivot - ods Tested with Version: 6.3.0.0.alpha0+ Build ID: c7ad7849d54fd3dad67e7779102f65b8b2f04881 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; after save as xlsx I can open pivot in excel2010. We need your .ods file to reproduce the bug.
Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
I opened a similar bug report, bug 123421 on various pivot table export issues, and noted that the file exported from LO 6.1.0.3 wasn't even a proper pivot table, and your version is close to that. Pradip, please give it a try with a 6.3 daily build from here: https://dev-builds.libreoffice.org/daily/master/
Hi, I tried with 6.3 libreoffice. Created pivot report and save as .xlsx in Linux machine.Tried to open the same file in windows machine with Ms office. Issue:Missing some functionalities of pivot report. but after click refresh button i can get all pivot functionalities there. Is there any fix for to overcome the refresh button click?
Please attach a sample ODS created in LibreOffice, an already buggy file is not useful in itself.
Created attachment 149530 [details] atached the xlxs file created in lunix machine Attached the xlsx file created in linux machine with libreoffice 6.3
Again, please attach the spreadsheet in ODS format, so the correctness of export can be tested both now and after a future fix.
Created attachment 149532 [details] ODS with pivot table created in Calc Attached the requested ods file also created from linux system
Hi Team, Any update on my request please? Regards, Pradip
Dear Baron, Can I have any update please. Regards, Pradip
correcting status
Thanks for the sample, Pradip! I can confirm the loss of functions in Excel until the pivot table is refreshed. Another very simple sample for repro (an XLSX created in Excel): attachment 133861 [details]. - Roundtrip the sample in Calc, and open in Excel. - Right click on a cell inside the table. => The menu has a lot fewer options than the original until the pivot table is refreshed. Observed using LO 6.3.0.0.alpha0+ (4f810905fa74128871f2fe924a3d28a79f4e4261) / Windows 7.
Created attachment 149810 [details] Screenshot of Excel's context menu
Similar behaviour on Windows machine: Create ods with pivot table in calc (LO 7.2.2) Save copy as xlsx (Excel 2007-365) Open with LO: OK Open xlsx with EXCEL (MS Office Professional Plus 2019): Failure report screen. When you commit, pivot table is converted to text Open ods directly with MSO EXCEL: error screen but works fine Open ods with MS EXCEL and save: pivot table stays in proper shape Open ods in LO and save copy as xls Open xls in MS EXEL: OK
*** Bug 150954 has been marked as a duplicate of this bug. ***