Bug 100666 - Freeze First Row/Column commands only works if the first row/column is visible on the screen
Summary: Freeze First Row/Column commands only works if the first row/column is visibl...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.0.1 rc
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard: target:7.5.0 inReleaseNotes:7.5
Keywords: implementationError
: 109173 112659 132554 148538 (view as bug list)
Depends on:
Blocks: Cell-Freeze
  Show dependency treegraph
 
Reported: 2016-06-29 03:04 UTC by Tim Richardson
Modified: 2023-01-20 15:03 UTC (History)
10 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tim Richardson 2016-06-29 03:04:44 UTC
If I am in row 5000 of a spreadsheet and choose Freeze First Row, nothing happens.
If I scroll to the top of the spreadsheet and choose Freeze First Row, the first row freezes.

I would expect the first row to freeze and become visible when I execute freeze first row, regardless of where I am in the spreadsheet.
Comment 1 Aron Budea 2016-06-29 05:58:09 UTC
Indeed, neither of Freeze First Row/Column works if the first row/column is not visible on screen.

Reproduced with 5.2.0.1 and master builds in Windows 7.
Comment 2 Gülşah Köse 2016-06-29 11:32:07 UTC Comment hidden (obsolete)
Comment 3 Gabor Kelemen (allotropia) 2017-07-18 07:29:07 UTC
*** Bug 109173 has been marked as a duplicate of this bug. ***
Comment 4 Timur 2017-09-26 13:36:19 UTC
*** Bug 112659 has been marked as a duplicate of this bug. ***
Comment 5 Yousuf Philips (jay) (retired) 2017-09-26 15:42:07 UTC
@Eike: can you have a peek at this issue?
Comment 6 QA Administrators 2018-09-27 02:42:52 UTC Comment hidden (obsolete)
Comment 7 Aron Budea 2018-09-27 03:15:57 UTC
Still buggy in 6.1.1.2.
Comment 8 Tim Richardson 2018-09-27 03:35:28 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2019-09-28 03:05:24 UTC Comment hidden (obsolete)
Comment 10 Tim Richardson 2019-09-28 06:51:29 UTC Comment hidden (obsolete)
Comment 11 Tim Richardson 2019-12-08 03:21:26 UTC
bug is still in 6.3
Comment 12 Xisco Faulí 2020-05-11 14:46:17 UTC
*** Bug 132554 has been marked as a duplicate of this bug. ***
Comment 13 Andrej Kvasnica 2020-05-11 15:21:12 UTC
same behaviour in latest 6.4.3.2 release
same behaviour in latest 7.0.0.0.alpha1 build 6a03
Comment 14 Stéphane Guillou (stragu) 2021-06-22 04:05:18 UTC
reproduced in latest daily:

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: e3086b58eb5427d520b86c185f9d911bb6f7a3a0
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-06-21_15:37:11
Calc: threaded

and 7.2 beta1 as well:

Version: 7.2.0.0.beta1 / LibreOffice Community
Build ID: c6974f7afec4cd5195617ae48c6ef9aacfe85ddd
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

There is no message to explain why it didn't work.
A frozen top row is most useful when the top row is not visible, so I suspect most people wanting to freeze the top row would encounter this issue.
Comment 15 Aron Budea 2022-06-04 07:01:40 UTC
*** Bug 148538 has been marked as a duplicate of this bug. ***
Comment 16 Aron Budea 2022-07-20 02:44:51 UTC
This is actually the same as bug 112641. Since that bug seems to have more relevant discussion, closing this one in favor of that.

*** This bug has been marked as a duplicate of bug 112641 ***
Comment 17 Justin L 2023-01-20 14:58:32 UTC
This was fixed in LO 7.5 with commit e6bc90aa8a959e08abf4b5c10d793ff9a549efe4.

I'm going to split it off from bug 112641 because that bug is still open, but most of the duplicates apply to this specific situation, while that bug report is actually talking about something quite different (but related).
Comment 18 Justin L 2023-01-20 14:59:14 UTC
*** Bug 109173 has been marked as a duplicate of this bug. ***
Comment 19 Justin L 2023-01-20 14:59:34 UTC
*** Bug 112659 has been marked as a duplicate of this bug. ***
Comment 20 Justin L 2023-01-20 15:02:45 UTC
*** Bug 132554 has been marked as a duplicate of this bug. ***
Comment 21 Justin L 2023-01-20 15:03:08 UTC
*** Bug 148538 has been marked as a duplicate of this bug. ***