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
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.
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.
Hello, you can select cell B2 and click on the "Freeze rows and columns" button on the toolbar.