Bug 157399 - The dynamic tables are not saved in XLSX format files
Summary: The dynamic tables are not saved in XLSX format files
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency tree / graph
 
Reported: 2023-09-23 16:55 UTC by GIRAUD François
Modified: 2023-09-26 21:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
File xlsx with pivot table (9.61 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-09-23 18:37 UTC, m_a_riosv 		Details
ODS file with pivot table in sheet "Liste par catégo" (98.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-09-24 20:26 UTC, GIRAUD François 		Details
XLSX file without pivot table in sheet "Liste par catégo" (606.76 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-09-24 20:27 UTC, GIRAUD François 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description GIRAUD François 2023-09-23 16:55:10 UTC 
Description:
When the ODS file is saved as XLSX or XLS file, the dynamic tables are lost ; only results are kept, not the structure.

Steps to Reproduce:
1.Create a Dynamic table
2.Save the file as ODS
3.Close LibreOffice
4.Reopen the ODS file
5.Dynamic table is present as usual
6.Save the file as XLSX file
7.Close LibreOffice
8.Reopen the file XLSX
9.Dynamic sheet is present but contents only data and formats ; without Dynamic strucure

Actual Results:
Dynamic sheet is present but contents only data and formats ; without Dynamic strucure

Expected Results:
Dynamic table


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded
Comment 1 m_a_riosv 2023-09-23 18:37:02 UTC 
Created attachment 189775 [details]
File xlsx with pivot table

Please attach an ODS sample file, to test.
Attached file works for me.
Comment 2 m_a_riosv 2023-09-23 18:49:41 UTC 
Looks like a duplicate of tdf#150954
Comment 3 GIRAUD François 2023-09-24 20:26:09 UTC 
Created attachment 189796 [details]
ODS file with pivot table in sheet "Liste par catégo"
Comment 4 GIRAUD François 2023-09-24 20:27:33 UTC 
Created attachment 189797 [details]
XLSX file without pivot table in sheet "Liste par catégo"
Comment 5 QA Administrators 2023-09-25 03:14:14 UTC Comment hidden (obsolete)
Comment 6 raal 2023-09-26 21:27:44 UTC 
(In reply to GIRAUD François from comment #3)
> Created attachment 189796 [details]
> ODS file with pivot table in sheet "Liste par catégo"

I can confirm with Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0c4913e03e8427a576138601958f2dbf13b8c37b
CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)