(In reply to BogdanB from comment #23) > Roland, please mark this bug as resolved. > I will mark as Verified later, it ok now. Thanks for fixing.
Thanks for testing. This bug caused a regression for notes and patterns. I fell in my own trap. In my unit tests, my test sample started in A1, i.e. a special case. I've found the problem and I'll submit a patch after https://gerrit.libreoffice.org/c/core/+/116073/9 is merged. After, this regression is fixed, I'll set bugs 68976, 71058, 142065, 142201 together to RESOLVED FIXED. -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to libreoffice in Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells Status in LibreOffice: In Progress Status in libreoffice package in Ubuntu: Fix Committed Bug description: Step to reproduce: 1. Open the attached ods file. 2. Select I12 to L16 and cut this region (Ctrl+X). (This bug doesn't occur with copy) 3. Select I5 and open Paste Special dialog (Shift+Ctrl+V). 4. Enable "Transpose" option and Click "OK" Then, values of some cells in C9 to E10, which are not related to blank cells are changed: C9: =C3/SUM(C$3:C$6) -> K7/SUM(C$3:C$6) D9: =D3/SUM(D$3:D$6) -> L7/SUM(D$3:D6) E9: =E3/SUM(E$3:E$6) -> M7/SUM(E$3:E$6) C10: =C4/SUM(C$3:C$6) -> K8/SUM(C$3:C$6) D10: =D4/SUM(D$3:D$6) -> L8/SUM(D$3:D6) E10: =E4/SUM(E$3:E$6) -> M8/SUM(E$3:E$6) My environment is Ubuntu 14.04 LibreOffice 4.2.6.3 To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : desktop-packages@lists.launchpad.net Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp