[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
** Changed in: libreoffice (Ubuntu) Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
Great! You solved it! I tested again and it is ok in Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: ec629c5ee22d02f99d66a5cf975ce239876b7f4d CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
** Changed in: df-libreoffice Status: In Progress => Fix Released -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
scito committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c82d96da1c9a03e1742f2f5a7a93b9993c96a0a0 tdf#68976 fix paste transposed regression for notes/patterns It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
I've submitted a patch: https://gerrit.libreoffice.org/c/core/+/116501 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
(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 Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
** Changed in: libreoffice (Ubuntu) Status: Confirmed => Fix Committed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
Roland, please mark this bug as resolved. I will mark as Verified later, it ok now. Thanks for fixing. Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: 42d2b2d55a27f11153ea1713737d93540a19211d CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
scito committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/de4c23fb38a7848e1030075b9c15cbb5c558694c tdf#68976 cut paste transposed: fix wrong position in clipdoc It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
I've submitted a patch: https://gerrit.libreoffice.org/c/core/+/115535 Waiting for review -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
** Changed in: df-libreoffice Status: Confirmed => In Progress -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
I've found the problem. Working on a solution. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491]
Confirmed Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 4f7bc49bce261f1cf206d25f0299fd080a9f5d28 CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
Synchronising bug status with upstream. ** Changed in: libreoffice (Ubuntu) Status: Triaged => Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
Launchpad has imported 19 comments from the remote bug at https://bugs.documentfoundation.org/show_bug.cgi?id=68976. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2013-09-05T11:03:04+00:00 Leshiy wrote: I was working with the spreadsheets and noticed this little gem. The value in the formula with the anchored cells (e.g. $A$1) are updated when i cut and paste in unrelated rows. Steps to reproduce: Enter value 1234 in cell A1 Enter values 5,2,3 in cells A3, A4 and A5 respectively Enter formula ($A$1-ABS(A3))*-1 in cell B3 Drag the formula to fill other 2 cells Now you have values -1229, -1232 and -1231 in cells B3, B4 and B5 Enter values 2, 3, 4 in cells A7, B7 and C7 Select these cells and cut them. Click on A7 cell Paste special: Number and Transpose checked, Operations: None, Shift Cells: Don't shift Values in cells B3, B4 and B5 change to 2, 0 and 1 respectively Formulas are updated to ($A$7-ABS(A9))*-1, ($A$7-ABS(A4))*-1, ($A$7-ABS(A5))*-1 in those cells. I am running opensuse 12.1 and official repository and Build ID: 350m1(Build:413) This also happens on Windows OS Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/1 On 2013-09-09T04:22:47+00:00 Jmadero-dev wrote: Thank you for reporting this issue! I have been able to confirm the issue on: Version 4.0.4 Platform: Bodhi Linux 2.2 x64 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well. Marking as: New (confirmed) Major - loss (change) of data High - default seems appropriate Indeed - quite the gem ;) Thanks for catching this + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org /get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/3 On 2013-10-30T16:30:30+00:00 Ralfs-mail-address wrote: I suggest the interim solution to disable "Paste Special" after cutting cells. The advantage is obvious: Loss or change of data are avoided. I experienced the consequences of this bug in a complex spreadsheet. The changes of links can be difficult to detect and to fix again. I do not see substantial disadvantages of disabling "Paste Special" after cutting cells because formula links are not shifted as expected after cutting and inserting with "Paste Special". I reported this unexpected behaviour with bug 71058 "EDITING: Cut and paste special does not shift formula links as expected". If cells are cut and then pasted normally (i.e. with "Paste" instead of "Paste Special"), all formula links to these cells point to the new cell positions after pasting the cells. This expected shift of formula links does not occur with the command "Paste Special". Formula links still point to the old positions of the moved cells. Therefore, "Cut" and "Paste Special" leads to the same result as "Copy" and "Paste Special" with subsequent deletion of the old cells. Thus disabling "Paste Special" after cutting cells does not lead to a loss of functionality. It can be replaced in the workflow by "Copy" and "Paste Special" with subsequent deletion of the old cells. A loss of functionality occurs only if bug 71058 can be fixed by aligning the behaviour of "Paste Special" with "Paste" after cutting cells. MS Excel 2007 does not offer the full set of "Paste Special" options after cutting cells either. I do not have access to later Excel versions. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/5 On 2013-10-30T19:20:45+00:00 Ralfs-mail-address wrote: (In reply to comme
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
** Bug watch added: Document Foundation Bugzilla #68976 https://bugs.documentfoundation.org/show_bug.cgi?id=68976 ** Changed in: df-libreoffice Importance: High => Unknown ** Changed in: df-libreoffice Status: Confirmed => Unknown ** Changed in: df-libreoffice Remote watch: freedesktop.org Bugzilla #68976 => Document Foundation Bugzilla #68976 ** Changed in: libreoffice (Ubuntu) Status: Incomplete => Triaged -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
** Changed in: libreoffice (Ubuntu) Status: Triaged => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells
This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: "Cut" and "Paste special" -> "Transpose" affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: Cut and Paste special - Transpose affects other cells
** Summary changed: - [upstream] calc: Cut and Paste special - Transpose effects other cells + [upstream] calc: Cut and Paste special - Transpose affects other cells -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: Cut and Paste special - Transpose affects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: Cut and Paste special - Transpose effects other cells
** Tags added: trusty -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: Cut and Paste special - Transpose effects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: calc: Cut and Paste special - Transpose effects other cells
** Summary changed: - calc: Cut and Paste special - Transport effects other cells + calc: Cut and Paste special - Transpose effects other cells ** Description changed: 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 Transport option and Click OK + 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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: calc: Cut and Paste special - Transpose effects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: calc: Cut and Paste special - Transpose effects other cells
Thank you for reporting this bug and helping to make Ubuntu better. This bug has already been reported to the LibreOffice developers - https://bugs.freedesktop.org/show_bug.cgi?id=68976 Reproducible via your spreadsheet and one in the upstream bug as well. ** Bug watch added: freedesktop.org Bugzilla #68976 https://bugs.freedesktop.org/show_bug.cgi?id=68976 ** Also affects: df-libreoffice via https://bugs.freedesktop.org/show_bug.cgi?id=68976 Importance: Unknown Status: Unknown ** Changed in: libreoffice (Ubuntu) Status: New = Triaged ** Summary changed: - calc: Cut and Paste special - Transpose effects other cells + [upstream] calc: Cut and Paste special - Transpose effects other cells ** Changed in: libreoffice (Ubuntu) Importance: Undecided = High -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: [upstream] calc: Cut and Paste special - Transpose effects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: [upstream] calc: Cut and Paste special - Transpose effects other cells
Launchpad has imported 8 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=68976. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2013-09-05T11:03:04+00:00 Leshiy wrote: I was working with the spreadsheets and noticed this little gem. The value in the formula with the anchored cells (e.g. $A$1) are updated when i cut and paste in unrelated rows. Steps to reproduce: Enter value 1234 in cell A1 Enter values 5,2,3 in cells A3, A4 and A5 respectively Enter formula ($A$1-ABS(A3))*-1 in cell B3 Drag the formula to fill other 2 cells Now you have values -1229, -1232 and -1231 in cells B3, B4 and B5 Enter values 2, 3, 4 in cells A7, B7 and C7 Select these cells and cut them. Click on A7 cell Paste special: Number and Transpose checked, Operations: None, Shift Cells: Don't shift Values in cells B3, B4 and B5 change to 2, 0 and 1 respectively Formulas are updated to ($A$7-ABS(A9))*-1, ($A$7-ABS(A4))*-1, ($A$7-ABS(A5))*-1 in those cells. I am running opensuse 12.1 and official repository and Build ID: 350m1(Build:413) This also happens on Windows OS Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/0 On 2013-09-09T04:22:47+00:00 Jmadero-dev wrote: Thank you for reporting this issue! I have been able to confirm the issue on: Version 4.0.4 Platform: Bodhi Linux 2.2 x64 + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + As I've been able to confirm this problem on an earlier release I am changing the version number as version is the earliest version that we can confirm the bug, we use comments to say that the bug exists in newer versions as well. Marking as: New (confirmed) Major - loss (change) of data High - default seems appropriate Indeed - quite the gem ;) Thanks for catching this + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + LibreOffice is powered by a team of volunteers, every bug is confirmed (triaged) by human beings who mostly give their time for free. We invite you to join our triaging by checking out this link: https://wiki.documentfoundation.org/QA/BugTriage There are also other ways to get involved including with marketing, UX, documentation, and of course developing - http://www.libreoffice.org /get-help/mailing-lists/. Lastly, good bug reports help tremendously in making the process go smoother, please always provide reproducible steps (even if it seems easy) and attach any and all relevant material Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/1 On 2013-10-30T16:30:30+00:00 Ralfs-mail-address wrote: I suggest the interim solution to disable Paste Special after cutting cells. The advantage is obvious: Loss or change of data are avoided. I experienced the consequences of this bug in a complex spreadsheet. The changes of links can be difficult to detect and to fix again. I do not see substantial disadvantages of disabling Paste Special after cutting cells because formula links are not shifted as expected after cutting and inserting with Paste Special. I reported this unexpected behaviour with bug 71058 EDITING: Cut and paste special does not shift formula links as expected. If cells are cut and then pasted normally (i.e. with Paste instead of Paste Special), all formula links to these cells point to the new cell positions after pasting the cells. This expected shift of formula links does not occur with the command Paste Special. Formula links still point to the old positions of the moved cells. Therefore, Cut and Paste Special leads to the same result as Copy and Paste Special with subsequent deletion of the old cells. Thus disabling Paste Special after cutting cells does not lead to a loss of functionality. It can be replaced in the workflow by Copy and Paste Special with subsequent deletion of the old cells. A loss of functionality occurs only if bug 71058 can be fixed by aligning the behaviour of Paste Special with Paste after cutting cells. MS Excel 2007 does not offer the full set of Paste Special options after cutting cells either. I do not have access to later Excel versions. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/comments/2 On 2013-10-30T19:20:45+00:00 Ralfs-mail-address wrote: (In reply to comment #2) I received a comment to bug 71058. The comment implies that my suggested interim solution has disadvantages, because Cut and Paste Special behaves as expected unless Transpose is selected. Therefore
[Bug 1388491] [NEW] calc: Cut and Paste special - Transport effects other cells
Public bug reported: Step to reproduce: 1. Open the attached ods file. 2. Select I12 to L16 and cut this region (Ctrl+X). 3. Select I5 and open Paste Special dialog (Shift+Ctrl+V). 4. Enable Transport 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 ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Attachment added: Example sheet https://bugs.launchpad.net/bugs/1388491/+attachment/4251056/+files/example.ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: calc: Cut and Paste special - Transport effects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1388491] Re: calc: Cut and Paste special - Transport effects other cells
** Description changed: Step to reproduce: 1. Open the attached ods file. - 2. Select I12 to L16 and cut this region (Ctrl+X). + 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 Transport 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 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1388491 Title: calc: Cut and Paste special - Transport effects other cells To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1388491/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
