Bug 151671

Summary: Calc: Freeze Rows and Columns is freez the first rows or columns only
Product: LibreOffice Reporter: MARINA-SODA <m5382607036>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: normal CC: lobugs, miguelangelrv, rafael.palma.lima
Priority: medium    
Version: 7.5.0.0 alpha0+   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description MARINA-SODA 2022-10-21 04:20:21 UTC
Description:
When you choose Freeze Rows and Columns, calc freeze first rows or columns.
Same behavior as selecting Freeze First Row or Freeze First Column.

Steps to Reproduce:
1.Select any cell.
2.Choose View - Freeze Rows and Columns.


Actual Results:
Calc freeze your selected column or row.

Expected Results:
Calc freeze the first column or row.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Please operate according to the menu.
Comment 1 MARINA-SODA 2022-10-21 04:25:51 UTC
Q&A

--Why are you using 7.5 test ver?
Because major version have many critical bugs.
https://bugs.documentfoundation.org/show_bug.cgi?id=151576
https://bugs.documentfoundation.org/show_bug.cgi?id=150680

7.5 have this issue but still better,
https://bugs.documentfoundation.org/show_bug.cgi?id=150664
Comment 2 m_a_riosv 2022-10-21 15:07:22 UTC
Works fine for me.
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 4ccdfff0becb54d71fe6270b5eeae0daaf04ed93
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en- Calc: CL threaded Jumbo

Going to c3, every option does what's expected to do. Specially with Freeze rows&columns, up to column B and row 2 it's freeze.
Comment 3 Rafael Lima 2022-10-21 18:51:40 UTC
According to the help, the Freeze Rows and Columns command:

"Divides the sheet at the top left corner of the active cell and the area to the top left is no longer scrollable."

https://help.libreoffice.org/latest/en-US/text/scalc/01/07090000.html

I tested it here and it works as described.

I believe the OP was expecting it to work differently, by always freezing the first row and column even when a different cell is selected. Is that right?

If so, this is NAB.
Comment 4 MARINA-SODA 2022-10-23 02:07:03 UTC
This behavior has continued since Version 4, and I was wondering why there are two of the same functions. 

Now I tested once more, I got indeterminate result.
Freeze Rows and Columns,freezed at the top rows, freezed at the nth rows, etc and columns are not freezed.
Comment 6 QA Administrators 2023-04-23 03:26:21 UTC Comment hidden (obsolete)
Comment 7 lol 2023-04-23 17:33:42 UTC
Works as described in the help.

Tested with

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Comment 8 QA Administrators 2023-10-21 03:15:38 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2023-11-21 03:12:32 UTC
Dear MARINA-SODA,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp