Bug 80418

Summary: FILESAVE: Grouped columns not shown when saving as .xlsx
Product: LibreOffice Reporter: Guillermo Cotone <guillermo.cotone>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: normal CC: guillermo.cotone
Priority: medium    
Version: 4.2.4.2 release   
Hardware: Other   
OS: Linux (All)   
Whiteboard: BSA
Crash report or crash signature: Regression By:
Attachments: sample file

Description Guillermo Cotone 2014-06-23 18:28:52 UTC
Created attachment 101602 [details]
sample file

Problem description: 
When using the group/ungroup feature for columns, if the file is saved as .xlsx with column range grouped(collapsed) then after reopening the file, columns will be gone.
No folding button and ctrl+F2 won't work. Content can be still accessed through format->Column->show.
Looks like Collapsed="true" needs to be set.

If the file is open with Microsoft Office, it will suggest to repair the file due to improper  column naming and result in data lose.


Steps to reproduce:
1. Create a file with a few columns and group them.
2. Save the file as xlsx.
3. Open the file.

Current behavior:
Columns are hidden but not folded.

Expected behavior:
Folded columns/rows with the appropriate buttons/menus.

              
Operating System: Debian
Version: 4.2.4.2 release
Comment 1 ign_christian 2014-06-24 02:28:41 UTC

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