Bug 64163 - Freeze pane and scroll position not saved.
Summary: Freeze pane and scroll position not saved.
Status: RESOLVED DUPLICATE of bug 49742
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2013-05-02 18:13 UTC by Scott Drasnin
Modified: 2013-07-09 15:26 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Scott Drasnin 2013-05-02 18:13:29 UTC
Expected behavior:
Select a row (example: row 3).
Menu Window | freeze.
Scroll down to bottom row (example: row 1500).  Still see top frozen rows (2 rows in this example)
Edit some cell values on this row.
Save spreadsheet in Excel 2003 .xls format. Exit LibreOffice
[Thus far things work]
Re-open spreadsheet.
Desire: spreadsheet opens to last edited row (example: 1500) and top frozen rows visible (example: two rows).

Actual / error:
Upon re-open, the spreadsheet is opened viewing the top rows (position lost), and the freeze is not there (scrolling causes top rows to scroll away).

Extra Notes:
This operation worked as expected in LibreOffice 3.n.n, prior to upgrading to the version 4 (same file and all other conditions)
Comment 1 ign_christian 2013-05-09 10:05:46 UTC

*** This bug has been marked as a duplicate of bug 61060 ***
Comment 2 ign_christian 2013-05-30 14:12:19 UTC
Sorry..I made mistake, this bug isn't duplicate to bug 61060

But I can't reproduce on LO (Win7 32bit) -> cell position remebered after saving & reopening file
Comment 3 bfoman (inactive) 2013-06-26 13:29:39 UTC
On which sheet are you doing the freeze operation? Sheet 1?
Comment 4 Scott Drasnin 2013-06-30 00:47:26 UTC
Shrt answer: the problem occurs on multiple sheets, not the first, within the .xls file.

My real world use cases: 2 large spreadsheet files, each with multiple sheets (named tabs on the bottom).

In one case, the top/first sheet is a small summary panel, so doesn't really scroll at all. Some of the "interior" sheets do have the problem listed here.

In another, the first/top sheet does scroll, but does not exhibit this problem (e.g. freeze pane and position ARE maintained across saves/reloads on the top sheet).

So, in my usage, yes the problem may be specific the additional sheets within a the file. 

Note: I have tried variations of intentionally changing something on the topmost sheet before save--and that did not solve lost freeze and position problems on the other sheets.
Comment 5 bfoman (inactive) 2013-06-30 07:35:59 UTC
This is known issue with many duplicates. In general there is a problem when you use freeze beyond 2nd sheet in XLS files.

*** This bug has been marked as a duplicate of bug 49742 ***
Comment 6 Scott Drasnin 2013-07-03 21:22:53 UTC
Also related to:

Comment 7 Scott Drasnin 2013-07-09 15:26:39 UTC
Re: comment 2

Both problems still present in LibOff release
Version (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2)

for me.