I use the Window->Freeze setting in several of my worksheets. The Freeze settings are randomly lost either when the file is closed or when it is opened. Random means that none or several worksheets may lose the setting. In any event, the settings are lost, even in worksheets that were not modified in a session. This problem is especially true for XLS files. While I have not lost any data that I know of, it is alarming that LO does not reliably save all information about the spreadsheets. Out of fear of data getting lost as well, I have reverted back to MS Office.
See bug 50982.
*** Bug 50982 has been marked as a duplicate of this bug. ***
*** Bug 57169 has been marked as a duplicate of this bug. ***
See Bug 57169 for a good reproducible test case for this bug.
*** Bug 47174 has been marked as a duplicate of this bug. ***
*** This bug has been marked as a duplicate of bug 61060 ***
So sorry for the riot caused by me. It's different problem.
I'll reopened this bug, still happen on LO 220.127.116.11 (Win7 32bit)
*** Bug 63224 has been marked as a duplicate of this bug. ***
*** Bug 63103 has been marked as a duplicate of this bug. ***
*** Bug 62045 has been marked as a duplicate of this bug. ***
*** Bug 62074 has been marked as a duplicate of this bug. ***
Change version to: 3.5.0 -> oldest version known from Bug 47174
*** Bug 65369 has been marked as a duplicate of this bug. ***
I confirm the window-freeze randomly disappear when a file saved and then reopened.
1. Freeze some rows only (for title, etc), no data filter -> Freeze disappear after save
2. Freeze both row and column -> freeze (mostly) still appear after save
3. Data filter active -> window-freeze saved
That's all what I know.
*** Bug 64163 has been marked as a duplicate of this bug. ***
Since my reported problem was marked as duplicate, I'll add comments here as possible tools to solving.
The sheet scroll position also seems to be lost (not saved) at the same time as the freeze.
For me, this was a regression. LibrOff prior to 3.n (where I think n=3) handled this correctly.
Please comment here if you have some clues. Maybe you know exactly what version that it handled correctly? OO 3.3/3.4.1?
Such informations will help developers to backtrace.
> The sheet scroll position also seems to be lost (not saved) at the same time
> as the freeze.
I don't know whether that should be separated from this bug report. Perhaps someone have been reported that in another bug.
Have just checked..that behavior not happen on OOO 3.3.0 (Win XP). Freeze setting & cell position correctly saved.
I remember now..after doing some mistakes about marking such bugs :-)
This behavior not happen on LO 3.4.5 & 0OO 3.4.0 :
About cell position: Bug 57169 (with freeze), Bug 51066 (without freeze)
@Joel, perhaps this bug could be traced against 3.4.5? Will save lots of people here.. :)
*** Bug 67820 has been marked as a duplicate of this bug. ***
bug 67820 implies the root cause here may actually be a read error (on load), rather than a write error (on save) [Via testing a programmatically created source file.]
However, bug 51066 provides a work-around: save as .xls when viewing a sheet beyond the first two.
Run the experiment:
Load the sample file t.xls from bug 67820 into LibreOffice. See that Sheet 1 has a freeze set. Navigate to Sheet 3. It does not have a freeze set. Create a freeze on this Sheet 3. Save (back to .xls) while still viewing Sheet 3. Exit LibreOffice.
Reload the file: freeze on Sheet 3 preserved.
To developers / experimenters:
How did an on-save work-around help with an on-load bug?
How does the saved file differ from the original?
Specifically, how does the meta-data (freeze, scroll position) for Sheet 3 differ from Sheet 1 (unchanged?)? ... and from Sheet 4, 5, etc., which do not preserve the freeze or scroll position?
I have reproduced this bug as follows.
When saving in XLS format 'Window > Freeze' settings are only saved for:
current tab, all tabs to the left, first tab to the right but no other tabs to the right.
How to duplicate bug:
(1) Create a spreadsheet with five tabs.
(2) Set Window > Freeze on each of the five tabs.
(3) From tab 1 Save As Untitled_1.xls, From tab 2 Save AS Untitled_2.xls, repeat for tabs 3-5.
(4) Open each xls file to see this result:
Untitled_1.xls Freeze on tab 1-2 OK but Freeze on tabs 3-5 not saved.
Untitled_1.xls Freeze on tab 1-3 OK but Freeze on tabs 4-5 not saved.
Untitled_1.xls Freeze on tab 1-4 OK but Freeze on tabs 5 not saved.
Untitled_1.xls Freeze on tab 1-5 OK
Untitled_1.xls Freeze on tab 1-5 OK
The behavior is consistent (not random) for a few worksheets that I use. A work around is to save from the last or 2nd to last tab.
*** Bug 69249 has been marked as a duplicate of this bug. ***
(In reply to comment #25)
> *** Bug 69249 has been marked as a duplicate of this bug. ***
An addendum: Bug 69249 occurring in V18.104.22.168.
For a sheet on which only the panes have been changed and frozen it is impossible to save as LO does not register a change and the save option is greyed out.
(In reply to comment #26)
> An addendum: Bug 69249 occurring in V22.214.171.124.
> For a sheet on which only the panes have been changed and frozen it is
> impossible to save as LO does not register a change and the save option is
> greyed out.
This issue is bug 61060 and is fixed in 4.0.4.
*** Bug 71178 has been marked as a duplicate of this bug. ***
*** Bug 56415 has been marked as a duplicate of this bug. ***
*** Bug 71383 has been marked as a duplicate of this bug. ***
Hey, I can't believe my eyes..but bug seems not occured in LO 126.96.36.199 (running Ubuntu 12.04 32bit)
Anyone can confirm ?
Confirmed, the bug no longer occurs when going though my test in comment 24.
Thanks to whoever fixed this bit of LO.
> Thanks to whoever fixed this bit of LO.
Yes..many thanks to the mysterious guy ;)
Let's mark this bug WFM