Bug 150757 - Freeze setting for rows and columns not saved
Summary: Freeze setting for rows and columns not saved
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Freeze
  Show dependency treegraph
Reported: 2022-09-02 13:13 UTC by marco
Modified: 2023-03-02 10:34 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description marco 2022-09-02 13:13:25 UTC
Formatted spreadsheet with rows and columns fixed when saved with calc release 7.4.0 are opened in standard smallest windows loosing formatting. This do not happens in previous release 7.3.4. I faced this problem also on different PC. My operating system is W10 Pro.

Steps to Reproduce:
1.The sheet has 22 fixed rows and 4 columns. in total there are 1000 rows and 19 columns.
2.I fixed 22 rows and 4 columns
3.the open window is 34 rows and 16 columns and rows and columns are regularly sliding keeping the fixed ones
4.I save the sheet.
5.when I open the sheet with version 7.3.4 it appears exactly as it was when saved
6.when I open the sheet with version it appears always a windows of 27 rows and 11 columns and it loose fixed rows and columns, so I have to put them again and any time that I open the sheet. 

Actual Results:
Tryed to save and save with fixed rows and columns but without results

Expected Results:
I hope somebody fix the bug so I can use release Actually I went back to release 7.3.4

Reproducible: Always

User Profile Reset: No

Additional Info:
no additional information
Comment 1 marco 2022-09-02 13:41:00 UTC
Strange thing... I was preparing a test sheet, empting my personal sheet of all the sensitive data and mantaining the structure... I saved it and opened and in this case the bug is not present.... it keeps fixed raws and columns... incredible... it seems that there is something in my personal filld shhet that causes this matter: but what??? Really impossible ti investigate....
Comment 2 Buovjaga 2022-09-02 14:26:13 UTC
Please attach an example document.
Change back to UNCONFIRMED after you have provided the document.
Comment 3 QA Administrators 2023-03-02 03:25:31 UTC Comment hidden (obsolete)
Comment 4 marco 2023-03-02 10:30:15 UTC
Matter solved. Using release from and follows situation is normal and when openining the sheet keep previous format. Ok