Bug 116663 - Ungrouping collapsed rows and columns leaves them hidden
Summary: Ungrouping collapsed rows and columns leaves them hidden
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 142736 (view as bug list)
Depends on:
Blocks: Group&Outline
  Show dependency treegraph
 
Reported: 2018-03-27 15:18 UTC by Aron Budea
Modified: 2024-01-11 12:18 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample with grouped rows (6.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-27 15:18 UTC, Aron Budea
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2018-03-27 15:18:04 UTC
Created attachment 140917 [details]
Sample with grouped rows

Open the attached sample sheet with rows 11-20 grouped and collapsed.
Remove grouping of rows.

=> Rows 11-20 remain hidden.

While it's true that a collapsed group is hidden, when grouping is removed, I would expect the group effect (ie. the collapsing) to be removed as well.

Observed using LO 6.0.2.1 & 3.3.0 / Ubuntu 17.10.
Comment 1 m_a_riosv 2018-03-27 15:57:29 UTC
Seems it happens collapsing while in a cell of colapsed rows and without move from there then ungroup.
Comment 2 Timur 2018-03-27 16:15:51 UTC Comment hidden (obsolete)
Comment 3 Aron Budea 2018-03-27 21:34:13 UTC
(In reply to Timur from comment #2)
> If I understand, first you hid the rows than grouped, than ungrouped and you
> expect them to be also shown/unhidden. 
> I don't see why or you didn't explain how sample was created. 
> So I don't agree with New.
You're right, I could've been clearer. In my defense, "rows 11-20 grouped and collapsed" contains an ordering, and it seemed to be the only obvious way. Note how once you hide rows 11-20, you can't group them, because you have to select the first and last row to be grouped, and they're all hidden.
Comment 4 Timur 2018-03-28 07:57:04 UTC
OK.
1. group rows 11-20 via Data - Group and Outline - Group...
2. optionally hide rows 14-16
3. collapse grouped rows 11-20 via "-" or Data - Group and Outline - Hide Details
4. expand grouped rows 11-20 via "+" or Data - Group and Outline - Show Details
see that all rows are shown
5. optionally hide rows 17-19
6. collapse grouped rows 11-20 again
7. remove grouping of rows via Data - Group and Outline - UnGroup...
see that all rows 11-20 remain hidden
Expected: rows 11-20 are shown and don't remain hidden
Note: it could be better that rows 17-19 remain hidden but doesn't seems possible with the current logic of hiding and showing grouped rows.
Comment 5 QA Administrators 2019-03-29 04:02:58 UTC Comment hidden (obsolete)
Comment 6 Aron Budea 2019-04-08 01:59:14 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-04-08 03:39:11 UTC Comment hidden (obsolete)
Comment 8 Timur 2021-08-03 07:37:53 UTC
Repro 7.3+
Comment 9 Timur 2021-08-03 07:43:36 UTC
*** Bug 142736 has been marked as a duplicate of this bug. ***
Comment 10 QA Administrators 2023-08-04 03:18:50 UTC Comment hidden (obsolete)
Comment 11 Colin 2023-08-04 07:22:54 UTC
Version: 7.4.7.2 (x64) / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

Still present
Not much more than a cosmetic issue as the rows (or columns) can simply be unhidden with right click on the selected adjacent header segments and "show rows"
Comment 12 QA Administrators 2023-08-05 03:05:22 UTC Comment hidden (obsolete)
Comment 13 Timur 2024-01-11 10:54:25 UTC
Repro 24.8+