Bug 81480 - Show menuitem has no function in some cases
Summary: Show menuitem has no function in some cases
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.5.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 115304 (view as bug list)
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2014-07-18 04:45 UTC by helplibreoffice
Modified: 2018-01-30 12:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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. ***