Bug 138054 - FILESAVE XLSX Multiple groups of columns are exported as one group
Summary: FILESAVE XLSX Multiple groups of columns are exported as one group
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.2.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 144657 (view as bug list)
Depends on:
Blocks: XLSX Group&Outline
  Show dependency treegraph
 
Reported: 2020-11-07 20:04 UTC by Andrei Dragomirescu
Modified: 2021-09-22 14:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Example file with grouped columns (7.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-11-09 12:38 UTC, NISZ LibreOffice Team
Details
The example file saved as XLSX in Calc 7.1 alpha (4.82 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-11-09 12:39 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document and its saved version side by side in Calc (38.19 KB, image/png)
2020-11-09 12:40 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Andrei Dragomirescu 2020-11-07 20:04:13 UTC
Description:
When, in LibreOffice Calc, I create different groups from adjacent columns by pressing F2, I find these groups combined into a single one after saving in XLSX format, closing and reopening the spreadsheet. This is not the behavior I expect. What I expect is to find my data grouped according to my choice. This bug does not appear when I save in ODS format. (Sometimes I need the XLXS format for better compatibility with my colleagues.)

Steps to Reproduce:
1. Select columns A and B. Press F2.
2. Select columns C and D. Press F2. 
3. Select columns E and F. Press F2.
4. Save the spreadsheet in XLSX format.
5. Close the spreadsheet.
6. Open the spreadsheet.

Actual Results:
The three groups, namely A-B, C-D, and E-F, become a single group A-F after reopening the spreadsheet.

Expected Results:
The three groups, namely A-B, C-D, and E-F, should have remained distinct, as they where created.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.0.2.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: ro-RO (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.2_rc2-0ubuntu0.20.04.2
Calc: threaded
Comment 1 NISZ LibreOffice Team 2020-11-09 12:38:35 UTC
Created attachment 167132 [details]
Example file with grouped columns
Comment 2 NISZ LibreOffice Team 2020-11-09 12:39:06 UTC
Created attachment 167133 [details]
The example file saved as XLSX in Calc 7.1 alpha

Version: 7.1.0.0.alpha1+ (x64)
Build ID: 00e5c63c35307faacf76a5e2ca7953c4208244ed
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 3 NISZ LibreOffice Team 2020-11-09 12:40:16 UTC
Created attachment 167134 [details]
Screenshot of the original document and its saved version side by side in Calc

Excel also sees one group instead of 3
Comment 4 NISZ LibreOffice Team 2021-09-22 14:18:43 UTC
*** Bug 144657 has been marked as a duplicate of this bug. ***