Created attachment 109002 [details]
Calctest.ods for tests
installed is Fedora's libreoffice-calc-18.104.22.168-2.fc20.x86_64 with kernel 3.17.2
a regression since update to 22.214.171.124-2
To show this I attached a spreadsheet (Calctest.ods) with 4 tabs: Jan, Feb, Mar, Apr
starting with tab "Feb" the cell "C3" is a reference of the cell "C12" of the previous tab ( Feb.C3==Jan.C12, Mar.C3==Feb.C12, ...)
since the update I get an error "Err:523" if I move in last tab "Apr" the selected cells "E23:F23" with the mouse to the right side.
If I press key "F9" all cells "C3" contain this error.
sometimes it seems to be necessary to save, close and reopen the spreadsheet and/or to move "Apr.E23:F23" back and forth.
what I mentioned is that for example the cell "Apr.C3=Mar.C12" reads "Apr.C3=C3" just after the move of "E23:F23" !
the reference "=Mar" is lost...
maybe related to bugs
Created attachment 109003 [details]
I can confirm also in a self-built 4.2.7
Bug 85282 is not related, applying that patch does not fix this.
I doubt this is related to bug 79770.
Applying the patch of bug 82936 fixes this.
*** This bug has been marked as a duplicate of bug 82936 ***
with 126.96.36.199-6 BUG is fixed.