Bug 115517 - Hidden rows cannot be shown again
Summary: Hidden rows cannot be shown again
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.4.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-02-07 13:54 UTC by Jan Vlug
Modified: 2018-02-07 14:39 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Vlug 2018-02-07 13:54:46 UTC 
When you hide a row in Calc, you cannot show it any more by using the Show Rows from the context menu.

I tested this on:
libreoffice-calc.x86_64                    1:5.4.4.2-4.fc27
6.0.0.3 (via flatpak)

I'm using Fedora 27, fully up to date on Wayland, Gnome.
Comment 1 Jan Vlug 2018-02-07 14:03:16 UTC 
I did some more testing. Apparently, this issue is only there when you select the neighbouring rows, before clicking Show Rows.

Example:
Hide row 12.
Select row 11 and 13. Click show rows. Row 12 stays hidden.
Select row 10 to 13 or row 11 to 14. Row 12 is shown again.
Comment 2 Jan Vlug 2018-02-07 14:08:01 UTC 
OK, I realised what I did wrong. I used CTRL when selecting the neighbouring rows, and SHIFT when selecting more rows. When I use SHIFT to select the both neighbouring rows, unhiding works.

I leave it up to you whether this bug should be closed or kept open, because it might be useful to make unhiding also work when you select the neighbouring rows by using CTRL instead of SHIFT.
Comment 3 Xavier Van Wijmeersch 2018-02-07 14:39:48 UTC 
I think its was mention like you stated, using shift to show the row/column again and ctrl for other behaviour. So closing this as not a bug, if there no objections.