Apache OpenOffice (AOO) Bugzilla – Issue 49287
Copy sheet and undo make freeze jump sheets
Last modified: 2017-05-20 11:13:18 UTC
(Note: found in 1.9.100 but this choice is currently unavailable...) I apologise for the issue title/summary, but English is not my first language and, try as I might, I could not do better. Copying sheets in a spreadsheet document wreak havoc with frozen cells. The frozen cell settings seems to jump from sheet to sheet or just disappear. Part I 1.With a new Calc document (Untitled1): 2.Select freeze some cells in sheet1 – move selection to (eg) C3 and select Window > Freeze. 3.Select Sheet2 and copy it in front of Sheet1 using Edit > Sheet > Move/Copy... dialog (no bug if you copy using drag'n'drop nor if you simply move the sheet). 4.Bug: the newly created sheet (Sheet2_2) now has the same frozen cells as Sheet1. 5.Undo. 6.Redo. Incoherence: Sheet2_2 has now no frozen cells. Part II 7.Undo (or restart with a fresh document: redo steps 1 and 2). 8.Create a new Calc document: Untitled2. 9.Copy Sheet1 from this Untitled2 in front of Sheet1 in Untitled1 either by ctrl+drag'n'drop or by Edit > Sheet > Move/Copy... dialog. 10.No (visible) bug: Sheet1_2 in first document appears correctly (no frozen cells) and Sheet1 is intact – everything seems correct 11.Undo. Bug: cells are no longer frozen in Sheet1, they are now in Sheet2. Part III For clarity's sake, I'll restart from fresh files. Close all. 1.Create a new Calc document: Untitled1. 2.Select Sheet2 and freeze some cells (move selection away from A1 and select Window > Freeze). 3.Copy Sheet2 in front of Sheet1 either by ctrl+drag'n'drop or by Edit > Sheet > Move/Copy... dialog. 4.Bug: no frozen cells in the newly created Sheet2_2 5.Undo. No visible bug. 6.Redo. Bug and incoherence: no more frozen cells in Sheet2 but now Sheet2_2 has them. 7.Restart with a fresh document: redo steps 1 and 2. 8.Copy Sheet2 after Sheet3 (“in end positionâ€) either by ctrl+drag'n'drop or by Edit > Sheet > Move/Copy... dialog. 9.No visible bug: frozen cells are correct in Sheet2 and in Sheet2_2. 10.Undo. No visible bug. 11.Redo. Bug: no more frozen cell in Sheet2. (Sheet2_2 is still correct.)
Hi Niklas, one for you. Frank
Reset assigne to the default "issues@openoffice.apache.org".