Bug 65369

Summary:	Window freeze doesn't stay when saving as .xls
Product:	LibreOffice	Reporter:	dfrerichs
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	dfrerichs, kdinse
Priority:	medium
Version:	4.0.4.1 rc
Hardware:	x86 (IA32)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Spreadsheet with eight worksheets

Description dfrerichs 2013-06-04 18:26:26 UTC

Created attachment 80301 [details]
Spreadsheet with eight worksheets

Windows XP SP3

LibreOffice 4.0.4.1 RC1

I have a spreadsheet that was created in MSOffice 2003 and is now being edited in Calc. This spreadsheet has multiple worksheets and I apply a Window freeze to each worksheet. When saving the document as an xls the freeze panes are not saved on subsequent worksheets. So if I edit and save worksheet #2, the freeze is no longer applied to worksheets 4 - 8. However, if you go to the final worksheet and save it, then reopen it, it works as expected. If the spreadsheet is saved as an .ods, this problem does not occur. It appears that this is similar to Bug #62074, which was marked as RESOLVED DUPLICATE of bug 61060. I have attached a spreadsheet that you can verify this behavior with.

Comment 1 ign_christian 2013-06-05 15:42:51 UTC

I made mistakes with that bugs. Also confirmed that freeze not applied after saving & reopening file on 3rd worksheet (right side from last worksheet position) and so on (LO 4.0.4.1 - Win7 32bit).

But I think this should be marked as duplicate to Bug 49742, as Bug 62074. So you can comment on that bug along with other previous reporters.

Feel free if you don't agree & want to REOPENED this with some reasons.

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

Comment 2 Brent Ruiz 2019-10-24 08:53:39 UTC

Save icon will still stay grayed out (https://run3az.com) and you will not be able to save document with frozen windows. You will need to make some other change to be able to save document with frozen windows.

Comment 3 lawerencepvines 2020-03-23 12:52:56 UTC

I hope this service you offer is a solution, thank you. (https://basketballlegends.fun)

Comment 4 pkinpum 2020-07-01 03:14:25 UTC

Livin' in a world where no one's innocent Oh, but at least we try, mmm Gotta live my truth, not keep it bottled in So I don't lose my mind, baby, yeah http://geometrydash-game.com