Issue 49287 - Copy sheet and undo make freeze jump sheets
Summary: Copy sheet and undo make freeze jump sheets
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.4
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2005-05-14 15:46 UTC by fousage
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description fousage 2005-05-14 15:46:42 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.)
Comment 1 frank 2005-06-13 09:58:48 UTC
Hi Niklas,

one for you.

Frank
Comment 2 Marcus 2017-05-20 11:13:18 UTC
Reset assigne to the default "issues@openoffice.apache.org".