Bug 139042 - Freeze Rows And Columns Only freezing a row OR a column
Summary: Freeze Rows And Columns Only freezing a row OR a column
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.0.0.beta1+
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-12-18 20:26 UTC by Andrew Weit
Modified: 2020-12-23 00:16 UTC (History)
2 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 Andrew Weit 2020-12-18 20:26:58 UTC
Description:
Document contains latitude data in columns and longitude data in rows. While attempting to freeze both column A and Row 1 (lat and long title cells) Calc only freezes either the row or the column. Attempted to select row 2 and column B to preserve title cells which yielded the same results.

Steps to Reproduce:
1. Open sample data to populate sheet
2. Select row 2 & column B
3. Right-click on either title of column or row.
4. Select Freeze rows and columns
5. Scroll either down or to the right depending on whether you right-clicked on the row or the column.

Actual Results:
If you right-clicked on the row title and froze the row, only the row will be frozen. If you right-clicked on the column title and froze the column, only the column will be frozen. The Freeze Rows and Columns option does not freeze both.

Expected Results:
Selecting both row 2 AND column B, right-clicking on either title, and selecting Freeze Rows and Columns should have frozen both row 1 and column B to preserve headings while scrolling through the data.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.4.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.0.4_rc2-0ubuntu0.20.04.2
Calc: threaded
Comment 1 Andrew Weit 2020-12-18 20:29:07 UTC
For the final release of 7.1 there could be one Freeze Cells option which would freeze your selection(s). Such as in this use case, it would be useful to freeze both row 1 and column A to preserve the lat/long information while scrolling through solar insolation values vis-a-vis NASA CERES data.
Comment 2 Peter S Anderson 2020-12-22 11:07:24 UTC
Hi Andrew,
If you want to freeze column A and Row 1, go to B2 and select the menu option:
View: Freeze Rows and Columns. The right click on a column or row is a toggle for freezing either a certain number of rows or columns but not both. It seems that to freeze both rows and columns you have to use the menu option.
Regards..... Peter.
Comment 3 raal 2020-12-23 00:16:24 UTC
Hello, you can select cell B2 and click on the "Freeze rows and columns" button on the toolbar.