<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Duplicate cells corrupted sheet after using keyboard to change sheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=111748">111748</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Duplicate cells corrupted sheet after using keyboard to change sheets
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.4.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>sandreas41@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>