Bug ID: 111748
           Summary: Duplicate cells corrupted sheet after using keyboard
                    to change sheets
           Product: LibreOffice
           Version: release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc

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 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:

New sheet
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.

select C1:C3
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

Reply via email to