Given a spreadsheet with multiple sheets. When multiple sheets are simultaneously selected then copying a row and pasting it enters the topmost row values into all of the selected sheets. In version LO4.3 and previous the behaviour of the row copy function on multiple selected sheets was to select the corresponding row from each selected sheet and paste that row into the corresponding sheet. For example: Given two sheets: SA and SB; where both sheets contain a row 11 with a cell A11 where each cell has the respective values: SA:A11=31 and SB:A11=55; and we perform all of the following actions while both sheets remain selected; and we select row 11 on SA; and we insert a new row at SA:11; and we copy row SA:12, having the contents of the former row SA:11; and we paste that copied row into row SA:11; then the following is observed: SA:A11=31; SA:A12=31; and SB:A11=31; <== this is not the expected or prior behaviour SB:A12=55. The expected result is: SA:A11=31; SA:A12=31; and SB:A11=55; SB:A12=55. This issue does not occur in OpenOffice-4.1.2 or earlier.
I confirm, but is this an intentional decision? (In reply to James B. Byrne from comment #0) > This issue does not occur in OpenOffice-4.1.2 or earlier. This is not relevant :) Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+ Build ID: 6b65a0e83c4798f117be61af91dbaebdc85e94b7 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-01-21_03:41:08 Locale: fi-FI (fi_FI)
Well let's set to NEW.
I confirm - The feature works as intended in version 4.2.8 as well but not since then. I fix for the latest version 5.1 would definitely be a big blessing
(In reply to u81 from comment #3) > I confirm - The feature works as intended in version 4.2.8 as well but not > since then. > Changing version.
Note: inserting a row is an irrelevant step.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dc9eac5a5f4f247ba5efb67931ffde61f2c8d5b6 Resolves: tdf#97158 CopyOneCellFromClip() does not handle multiple sheets It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=800920a7b0600b1677d231c514345fe9f6687d82&h=libreoffice-5-2 Resolves: tdf#97158 CopyOneCellFromClip() does not handle multiple sheets It will be available in 5.2.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9d07f557572bdeaeda8e923525c8895d79fc0d22 actually multiple destination sheets are handled, tdf#97158 follow-up It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dd38581b787f357ee88da7dfabeb596a894b5afe&h=libreoffice-5-2 actually multiple destination sheets are handled, tdf#97158 follow-up It will be available in 5.2.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Pending review https://gerrit.libreoffice.org/25682 for 5-1
Eike Rathke committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5e99baf433a3e3d372979cc74240de5c93f71319&h=libreoffice-5-1 Resolves: tdf#97158 CopyOneCellFromClip() does not handle multiple sheets It will be available in 5.1.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thank you very much Eike Rathke for the patch. I've just tested it in 5.1.4 and it does work i.e. - copy the same cell in multiple sheets and paste it to the same number of sheets in another file. However, the statusbar sum function still only shows the sum of the cells selected on the current sheet even though you multiple sheets selected. Any help on that issue would be much appreciated. Thanks once again for your time and valuable contribution.