Bug 158921

Summary: Exported pivot table with custom name field yields corrupt XLSX when opened in MSO
Product: LibreOffice Reporter: eisa01 <eisa01>
Component: filters and storageAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: aron.budea, miguelangelrv
Priority: medium Keywords: filter:xlsx
Version: 24.2.0.0 beta1+   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=60169
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 104839, 112416    
Attachments: Test case - export to xlsx

Description eisa01 2023-12-29 12:33:10 UTC 
Description:
Discovered while testing bug 60169, test case taken from there
The attachment has a custom label for the grand total field

Steps to Reproduce:
1. Export to xlsx
2. Open in MSO


Actual Results:
Be warned that the file is corrupt and need to be repaired

Expected Results:
No warning


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.0.0.beta1 (AARCH64) / LibreOffice Community
Build ID: 5f390384195b7264c6e52add9e90a39790285249
CPU threads: 10; OS: macOS 14.2; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 eisa01 2023-12-29 12:34:28 UTC 
Created attachment 191627 [details]
Test case - export to xlsx
Comment 2 m_a_riosv 2023-12-30 01:53:20 UTC 
Reproducible
Version: 24.2.0.0.beta1 (X86_64) / LibreOffice Community
Build ID: 5f390384195b7264c6e52add9e90a39790285249
CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Microsoft® Excel® para Microsoft 365 MSO (versión 2311 compilación 16.0.17029.20028) de 64 bits