Bug 81480

Summary:	Show menuitem has no function in some cases
Product:	LibreOffice	Reporter:	helplibreoffice
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	classicalcanine, suokunlong
Priority:	medium
Version:	4.2.5.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108364

Description helplibreoffice 2014-07-18 04:45:35 UTC

Sometimes the Show menuitem is enabled but has no function.

To replicate:
1. Create new spreadsheet
2. Right click on Column B
3. Select 'Hide' menuitem
4. Right click on Column A
5. Select 'Show' menuitem
6. Notice nothing happens
7. Right click on Column C
8. Repeat steps 5-6

Either the 'Show' menuitem should be disabled when it does nothing, or preferably it should show a single hidden column/row when one is adjacent, and possibly show a dialog box when the function is ambiguous.

Comment 1 Kevin Suo 2014-07-18 05:30:23 UTC

When column B is hided, only click on cloumn A or column C will not show column B.
This is intended, and is documented on the online/offline help, see:
https://help.libreoffice.org/Calc/Show


>Either the 'Show' menuitem should be disabled when it does nothing, or preferably it should show a single hidden column/row when one is adjacent, and possibly show a dialog box when the function is ambiguous.

A agree with your idea. Let's make this as a feature request.

Comment 2 helplibreoffice 2014-07-18 19:57:05 UTC

Good idea.

I also propose that we consider whether the functionality should be different.

If a user hides a column/row with Hide, it seems like it would be logical that they then could immediately use Show to make it appear.  The current implementation requires selecting at least two columns/rows to accomplish this (in most cases), which users may find confusing and frustrating.

Comment 3 Telesto 2018-01-30 12:19:27 UTC

*** Bug 115304 has been marked as a duplicate of this bug. ***