Bug 146061 - Freeze rows and Columns inconsistent, depend on visible area
Summary: Freeze rows and Columns inconsistent, depend on visible area
Status: RESOLVED DUPLICATE of bug 124653
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-12-05 14:32 UTC by raal
Modified: 2023-01-20 15:15 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
test file (118.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-12-05 14:32 UTC, raal 		Details
View All 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 raal 2021-12-05 14:32:34 UTC 
Description:
Freeze rows and Columns inconsistent, depend on visible area.

Steps to Reproduce:
open attached file
click to cell H5
Move visible area to hide cell H5. H5 is still selected.
Menu View > Freeze rows and Columns


Actual Results:
Only rows freezed

Expected Results:
Rows and columns freeze.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.4.0.0.alpha0+ / LibreOffice Community
Build ID: ba7db98cca3d8516697c94ef0d6af27db9e1655e
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 1 raal 2021-12-05 14:32:53 UTC 
Created attachment 176710 [details]
test file
Comment 2 LeroyG 2021-12-06 00:10:24 UTC 
"Move visible area to hide cell H5", in Description above, is equivalent to scroll to the right so that column H is no more visible.

Additionally:

If do you select H5 and scroll down so that line 5 is no more visible, and choose menu View - Freeze Rows and Columns, only columns freeze.

If do you select H5 and scroll right so that column H is no more visible, and scroll down so that line 5 is no more visible, and choose menu View - Freeze Rows and Columns, no lines nor columns freeze.

If do you select Z99 and scroll left so that column Z is no more visible, and scroll up so that line 99 is no more visible, and choose menu View - Freeze Rows and Columns, no lines nor columns freeze, AND line 99 is shown in the upper border of the edit window.


Version: 7.1.7.2 / LibreOffice Community
Build ID: c6a4e3954236145e2acb0b65f68614365aeee33f
CPU threads: 1; OS: Linux 4.12; UI render: default; VCL: kf5
Locale: es-MX (es_AR.UTF-8); UI: en-US
Calc: threaded
Comment 3 LeroyG 2021-12-06 23:41:33 UTC 
Reproducible:

Version: 7.1.7.2 / LibreOffice Community
Build ID: c6a4e3954236145e2acb0b65f68614365aeee33f
CPU threads: 1; OS: Linux 4.12; UI render: default; VCL: kf5
Locale: es-MX (es_AR.UTF-8); UI: en-US
Calc: threaded
Comment 4 Ezinne 2021-12-13 06:21:17 UTC 
This seems to be like a case from TDF#100666
Comment 5 Aron Budea 2022-07-20 02:47:38 UTC 
Let's mark this as duplicate of bug 112641.

*** This bug has been marked as a duplicate of bug 112641 ***
Comment 6 Justin L 2023-01-20 15:15:07 UTC 

*** This bug has been marked as a duplicate of bug 124653 ***