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.
Dear Andrei Dragomirescu, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug