Description: Your "enhanced???" Freeze command, to put it mildly is a PoCrap!!!!!!!!!!!!!!!!!! Followed your instructions but still could never Freeze 2 columns or freeze 7 rows in my spread sheets. Bring back the EASY TO USE old way!!!!!!!! Steps to Reproduce: 1.Try to freeze just two columns and it also freezes the rows!! 2.Try to freeze the top 7 rows and it just freezes one!! 3.Rewrite the instructions or just dump that PoCrap command!!!!!! Actual Results: Doesn't work as the instructions state Expected Results: Expected to be able to freeze the first 2 columns and the top 7 rows. IT DOES NOT WORK!!!!!!!!! Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
On LO 24.2.3 Debian testing package, to freeze the first 7 rows, here what I do: - right click on whole row 8 => contextual menu appears - select "Freeze Rows and Columns" OK to freeze the first 2 columns: - right click on whole column 3 => contextual menu appears - select "Freeze Rows and Columns" OK Now to freeze 7 rows and 2 columns, you can begin with rows: - right click on whole row 8 => contextual menu appears - select "Freeze Rows and Columns" - right click on whole column 3 => contextual menu appears - select "Freeze Rows and Columns" => it removes freeze of rows - select again "Freeze Rows and Columns" => it puts back freeze of rows and add freeze on both columns OK but the step "remove of freeze of rows" is weird and unexpected. Heiko/Xisco: in my last example, we shouldn't have the step "remove of freeze of rows". Ideally, we should be able to select column 3 and row 8 then use "freeze" options to freeze both in the same time.
(In reply to Julien Nabet from comment #1) > Now to freeze 7 rows and 2 columns 1. Click on cell C8. 2. Menu View > Freeze Rows and Columns.
(In reply to ady from comment #2) > (In reply to Julien Nabet from comment #1) > > Now to freeze 7 rows and 2 columns > > 1. Click on cell C8. > 2. Menu View > Freeze Rows and Columns. Indeed! :-)
Closing as "not a bug", seeing comment 3. Please also see: https://help.libreoffice.org/latest/en-US/text/scalc/guide/line_fix.html I can't see a bug, testing the freezing feature in 24.2. If you still think there is a bug, please explain and set back to "unconfirmed".