Bug ID: 111748
Summary: Duplicate cells corrupted sheet after using keyboard
to change sheets
Version: 220.127.116.11 release
My ods file became very corrupted after discovering and starting to use a
I first noticed this in 5.2.3, the version in Jessie-backports, so I downloaded
18.104.22.168 directly from TDF to see if it was fixed, nope. About shows:
Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
CPU threads: 1; OS: Linux 3.16; UI render: default; VCL: gtk2;
Locale: en-US (en_US.utf8); Calc: group
To duplicate the bug:
In cell A1 enter 1
Click + at bottom to Add sheet to end, now Sheet2 is active.
In B2 enter 2
A3 enter 3
Notice change to A3 has happened to ALL sheets AFTER pressing Ctrl+Shift+PgUp
or maybe it starts sticking after PgDown
B4 enter 4
A5 enter 5
change A5 color, or border, or bold, or italic, etc.
look at A5, all changes came through.
B6 enter 6
Undo does undo both Sheets at once.
More found during testing, In Sheet1, select A3:B4
Insert (move cells down)
see the insert was also performed on both sheets.
+ Add Sheet3
C1 enter 1
C2 enter 2
C3 enter 3
see C2 has 2
see both C1 and C2 have entries made elsewhere.
change background color
Now the changes go backwards toward Sheet 1 also, all 3 cells are changed.
But not here. This change only went 1 level. Why?
But if select C1, enter 5
See the 5 here now.
And the 5 is here too.
But Sheet2:C3 change entry to 9
Use mouse this time to click on Sheet1
C3 here is no longer connected. to Sheet 2.
It quickly becomes confusing which cell is mirrored like a symlink to
elsewhere. Soon the entire file becomes corrupted when I make changes to
multiple sheets in different locations, until the damage is finally noticed.
Blocks inserted, entries overwritten, etc.
Too late I saved the file, I'll have to go back to an older backup to fix this.
You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list