Bug 150757

Summary:	Freeze setting for rows and columns not saved
Product:	LibreOffice	Reporter:	marco <mikkem>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	ilmari.lauhakangas
Priority:	medium
Version:	7.4.0.3 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	109182

Description marco 2022-09-02 13:13:25 UTC

Description:
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 7.4.0.3 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 7.4.0.3. 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.
Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the document.

Comment 3 QA Administrators 2023-03-02 03:25:31 UTC Comment hidden (obsolete)

Dear marco,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping

Comment 4 marco 2023-03-02 10:30:15 UTC

Matter solved. Using release from 7.4.5.1 and follows situation is normal and when openining the sheet keep previous format. Ok