Bug 154562

Summary:	Can't unhide/show specific Columns/Rows
Product:	LibreOffice	Reporter:	Leona Go. <leona.gottfried>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	enhancement	CC:	stephane.guillou
Priority:	medium
Version:	7.3.7.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Leona Go. 2023-04-02 12:39:22 UTC

Description:
After hiding lots of Columns, there is no good method to show a single Column again.
For Sheets there's Sheet > Show Sheet…, but Columns must be right-clicked.

Steps to Reproduce:
1.Hide Columns A through E
2.Attempt to unhide/show less than all Columns

Actual Results:
Showing any of the leftmost hidden collumns is only possible by selecting them – either by selecting all with the sheet corner, or by entering eg. A:E in the Name Box – and then Right-Click > Show Columns

Expected Results:
There should be a Sheets > Show Columns… Dialog, or at least a Sheets > Show Colums.
A way to show only selected Columns that are not currently visible.


Reproducible: Always


User Profile Reset: No

Additional Info:
The same obviously applies to Rows

Comment 1 Leona Go. 2023-04-02 12:57:34 UTC

Ah dangit, it's hidden under Format > Columns > Show.

Comment 2 Leona Go. 2023-04-02 13:00:07 UTC

(In reply to Leona Go. from comment #1)
> Ah dangit, it's hidden under Format > Columns > Show.

I understand why it's there with the optimal width stuff, but I really expected it under Sheet or View :/

Comment 3 Stéphane Guillou (stragu) 2023-04-18 09:15:18 UTC

Thanks, Leona.
Marking as "Not a bug" as you found the menu entry, but please open a new report if you want to suggest enhancements to how the menus are organised! Thank you.