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.
With those shorcut several sheets at time are selected, and when several sheets are selected what you do in one is done in all. https://help.libreoffice.org/Calc/Applying_Multiple_Sheets https://help.libreoffice.org/Calc/Copying_to_Multiple_Sheets Resolved as not a bug, please if you are not agree reopen it.
(In reply to m.a.riosv from comment #1) > With those shorcut several sheets at time are selected, My bad. I confused with and without the Shift key. May I suggest a solution, call it a feature request. When multiple cells are selected, the row and column headers become highlighted. But when multiple sheets are selected, there is no indicator of this. May I suggest highlighting the non-active sheet tab along the bottom row, in the same highlight color. Thank you.
Selected sheets have withe background, while those not selected have their color. I know sometimes it's not too much visible the difference, if you want some improvement please report a new as enhancement about it.