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
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: 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
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. ***
Repro Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: df3b95a39472e18ea8acdaae447b7176e37a9256 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: threaded
Repro Version: 6.4.0.0.alpha1+ (x64) Build ID: 9bc848cf0d301aa57eabcffa101a1cf87bad6470 CPU threads: 8; OS: Windows 10.0 Build 22621; UI render: GL; VCL: win; Locale: fr-FR (fr_FR); UI-Language: en-US Calc: threaded
Repro Version: 6.3.0.0.alpha1+ (x64) Build ID: c98b1f1cd43b3e109bcaf6324ef2d1f449b34099 CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; Locale: fr-FR (fr_FR); UI-Language: en-US Calc: threaded
(In reply to Andrei Dragomirescu from comment #0) > Steps to Reproduce: The STR need correction: 1. Select columns A and B. Press F12. 2. Select columns C and D. Press F12. 3. Select columns E and F. Press F12. 4. Save the spreadsheet in XLSX format. 5. Close the spreadsheet. 6. Open the spreadsheet. "Group and Outline" export to XLSX seems to be supported since LO 5.3 (considering that in LO 5.2, no group is saved at all when saving as XLSX). I have not found Release Notes on this. The problem is already present in LO 5.3 when saving (and then closing and reopening) as XLSX. It is saved correctly as ODS. I have not tested saving as XLS format. So this seems to be an implementation error.
Repro Version: 6.2.0.0.alpha1+ Build ID: a20a2d7e0d28658f2d9089da076961a599833a28 CPU threads: 8; OS: Windows 10.0; UI render: GL; VCL: win; Locale: fr-FR (fr_FR); UI-Language: en-US Calc: threaded
(In reply to Sophie Sipasseuth from comment #9) > Repro > > Version: 6.2.0.0.alpha1+ This is already repro since LO 5.3 and up to current Dev 24.2 versions, as mentioned in comment 8, so no need to keep testing 6.x versions.