[Libreoffice-bugs] [Bug 111748] New: Duplicate cells corrupted sheet after using keyboard to change sheets

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=111748

            Bug ID: 111748
           Summary: Duplicate cells corrupted sheet after using keyboard
                    to change sheets
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sandreas41 at gmail.com

My ods file became very corrupted after discovering and starting to use a
keyboard shortcut.
I first noticed this in 5.2.3, the version in Jessie-backports, so I downloaded
5.4.0.3 directly from TDF to see if it was fixed, nope. About shows:
Version: 5.4.0.3
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:

New sheet
In cell A1 enter 1
Click + at bottom to Add sheet to end, now Sheet2 is active.
In B2 enter 2
Ctrl+Shift+PgUp
A3 enter 3
Ctrl+Shift+PgDown
Notice change to A3 has happened to ALL sheets AFTER pressing Ctrl+Shift+PgUp
or maybe it starts sticking after PgDown
B4 enter 4
Ctrl+Shift+PgUp
A5 enter 5
change A5 color, or border, or bold, or italic, etc.
Ctrl+Shift+PgDown
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)
Ctrl+Shift+PgDown
see the insert was also performed on both sheets.

+ Add Sheet3
C1 enter 1
Ctrl+Shift+PgUp
C2 enter 2
Ctrl+Shift+PgUp
C3 enter 3
Ctrl+Shift+PgDown
see C2 has 2
Ctrl+Shift+PgDown
see both C1 and C2 have entries made elsewhere.

select C1:C3
change background color
Ctrl+Shift+PgUp
Now the changes go backwards toward Sheet 1 also, all 3 cells are changed.
Ctrl+Shift+PgUp
But not here. This change only went 1 level. Why?

But if select C1, enter 5
Ctrl+Shift+PgDown
See the 5 here now.
Ctrl+Shift+PgDown
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170812/7c2631a8/attachment.html>