Description: The "Freeze rows and columns" item in the context menu of column and row numbers is confusing, because they apply to the rows above or columns to the left of the event source. It would help a lot if the context menu said "Freeze rows above" when the event source is a row number, and "Freeze columns to the left" if the source is a column number. Steps to Reproduce: 1. Right click on a row or column number. 2. Pick "Freeze rows and columns" item. Actual Results: If it's the first row/column, nothing is frozen. If it's not, the frozen row/column is different from the event source. Expected Results: Freeze the column or row (and those preceding it vertically or horizontally, as necessary) that I had right clicked on. Reproducible: Always User Profile Reset: No Additional Info: As this page shows, this is something that confounds users with some frequency. Having to look this kind of thing is very distracting and frustrating. <https://ask.libreoffice.org/t/freeze-row-function-does-not-work/31244/2> --- Version: 25.2.5.2 (X86_64) Build ID: 520(Build:2) CPU threads: 4; OS: Linux 6.15; UI render: default; VCL: kf6 (cairo+wayland) Locale: en-GB (en_GB.UTF-8); UI: en-US Calc: threaded
(In reply to Göktuğ Kayaalp from comment #0) > "Freeze rows above" ... and "Freeze columns to the left" Sounds good to me. But "left" is not right for right-to-left sheets. How about "Freeze rows before"?
(In reply to Heiko Tietze from comment #1) > (In reply to Göktuğ Kayaalp from comment #0) > > "Freeze rows above" ... and "Freeze columns to the left" > > Sounds good to me. But "left" is not right for right-to-left sheets. How > about "Freeze rows before"? Personally, if I was encountering it in the context menu for the first time, "before" would be a bit confusing to me initially but I would figure it out fairly quickly, I suppose. It would be much more user friendly, in my opinion, if in the case of an rtl spreadsheet the item read "Freeze columns to the right", unless it's too difficult to implement.
"Freeze rows and columns" (rather "Freeze Panes") is the command .uno:FreezePanes. As one command executed from either columns or rows we do not change the label conditionally. Might be possible with some effort- and in this case we could also distinguish between LTR and RTL.
+1 from me