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.
The three groups, namely A-B, C-D, and E-F, become a single group A-F after reopening the spreadsheet.
The three groups, namely A-B, C-D, and E-F, should have remained distinct, as they where created.
User Profile Reset: No
OpenGL enabled: Yes
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
Created attachment 167132 [details]
Example file with grouped columns
Created attachment 167133 [details]
The example file saved as XLSX in Calc 7.1 alpha
Version: 126.96.36.199.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
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
*** Bug 144657 has been marked as a duplicate of this bug. ***