Bug 150963 - "Freeze Rows and Columns" should be accessible not just through the view menu
Summary: "Freeze Rows and Columns" should be accessible not just through the view menu
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.0 alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-14 21:06 UTC by Eyal Rozenberg
Modified: 2023-03-28 09:55 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 Eyal Rozenberg 2022-09-14 21:06:46 UTC
One can split the view in Calc by dragging the top of the scroll bar - without using the menus. I believe it should then be possible somehow - e.g. by a right-click context menu or some other way - to freeze the resulting split, without going through the view menu.
Comment 1 m_a_riosv 2022-09-14 21:17:08 UTC
Have you tried customizing the right-click?, Menu/Tools/Customize - Context Menu
Comment 2 lol 2023-02-27 18:55:02 UTC
(In reply to m.a.riosv from comment #1)
> Have you tried customizing the right-click?, Menu/Tools/Customize - Context
> Menu

It is possible. So close this bug?
Comment 3 Eyal Rozenberg 2023-02-27 19:59:03 UTC
> So close this bug?

No.
Comment 4 m_a_riosv 2023-02-27 20:01:30 UTC
It is not long enough, the right-click menu?

-1
Comment 5 Eyal Rozenberg 2023-02-27 20:02:34 UTC
The toggle should be there by default, either:

1. When the sheet view is split, or
2. Always

I prefer option (1.), can live with option (2.)
Comment 6 Eyal Rozenberg 2023-02-27 20:03:43 UTC
Oh, also - if one can get this by right clicking the _split_, then - I see no need for it to be on the cell right-click menu.

Right now, the split itself has no right-click menu.
Comment 7 Heiko Tietze 2023-02-28 11:05:30 UTC
The sheet-split is a different approach and workflow than freezing the sheet.

The purpose of splitting the sheet into two viewports is to work in parallel on two random positions of the document. Could be entering a formula in line #2000 based on numbers in #1000. Or to copy individual cells from column X into XX.

Freezing the sheet keeps either a number of columns or rows in the view, or both. Typically this comes into play when you have column headers. The frozen part is not random but from zero until this column/row.

=> WF

The summary is about making Freeze accessible by other means than the View main menu. In fact we also provide this function at the context menu if you right click on col/row headers. And on the standard toolbar are row/col menu buttons that allow to freeze the first row/col. Not bad, IMO.
Comment 8 Heiko Tietze 2023-03-28 09:55:13 UTC
No further comment, comment in general contrary, resolving WF.