Bug 154490 - Libreoffice spreadsheets keeps unfreezing rows and columns yet the menu says they are still frozen.
Summary: Libreoffice spreadsheets keeps unfreezing rows and columns yet the menu says ...
Status: RESOLVED DUPLICATE of bug 143167
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: x86 (IA32) macOS (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-30 21:18 UTC by Colin
Modified: 2023-03-31 20:29 UTC (History)
0 users

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 Colin 2023-03-30 21:18:37 UTC
Description:
I work a lot with spreadsheets where I need to freeze the top row and a number of columns at the start of the sheet. Freezing them works perfectly, I position my cursor in the first cell outside the frozen area and select "Freeze Rows and Columns" from the "View" menu.  This places a tick against the menu item and freezes the rows and columns in place. I then save the spreadsheet as an ".ods" file (the default file extension).

Seemingly at random, when I open the spreadsheet again I find that no rows or columns are frozen any more, however the "Freeze Rows and Columns" menu item is ticked, seemingly indicating that they are.  In order to freeze the again I have to position the cursor in the appropriate cell (of the unfrozen spreadsheet), click the menu item to remove the tick, then click it again to trigger the action, freeze the rows and columns, and add the tick back, then save the spreadsheet again.  This has been occurring through at least the last three generations of Libreoffice (including the current one).  I have tried creating the spreadsheet from scratch again, and even uninstalling Libreoffice and reinstalling it, but the issue persists.

Steps to Reproduce:
1. Create a spreadsheet with headings in Row 1 and Labels in column 1
2. Position the cursor in row 2 column 2
3. Select "Freeze rows and columns"
 from the "View" menu
4. Save the spreadsheet
5. Close Libreoffice
6. Open Libreoffice
7. Open the spreadsheet

Actual Results:
Either the first row and column remains frozen and the "freeze rows and columns" menu entry is ticked
OR
No rows or columns are frozen but the "freeze rows and columns" menu entry is ticked still

Expected Results:
The rows and columns frozen to be still frozen whenever the spreadsheet is reloaded until the option is turned off.


Reproducible: Sometimes


User Profile Reset: Yes

Additional Info:
I work between an Intel iMac and a Metal MacBook, both running the same version number of Libreoffice at all times.  The spreadsheets are stored on the iCloud and are edited on both platforms depending on which machine I am using.

At no time is the spreadsheet open on both machines.

Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 12; OS: Mac OS X 13.3; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2023-03-31 04:56:50 UTC
Thanks Colin.
This has been reported in bug 143167.

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