Bug 154563 - Freeze Rows and Columns appears off by one
Summary: Freeze Rows and Columns appears off by one
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-04-02 13:04 UTC by Leona Go.
Modified: 2023-04-02 13:45 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Leona Go. 2023-04-02 13:04:27 UTC 
Description:
Freeze Rows and Column always leaves the selection's bottom right cell free.
When attempting to use the action with A1 selected, it leaves the impression of a broken feature.

Steps to Reproduce:
1. Select just the first row or column
2.On the header Right click > Freeze Rows and Columns

Actual Results:
Nothing happens

Expected Results:
The first row and or column gets frozen


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.3.7.2
Build ID: 30(Build:2)
CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
Comment 1 Julien Nabet 2023-04-02 13:45:12 UTC 
As indicated in https://help.libreoffice.org/latest/en-US/text/scalc/guide/line_fix.html, you must freeze the column c+1 or row r+1.

So:
- if you want to freeze column A, you must select column B and use freeze.
- if you want to freeze row 1, you must select row 2 and use freeze.