This bug is probably related to #91744 but is easily reproducible. It occurs when a spreadsheet has columns having named ranges with scope restricted to the sheet. If a block of data is copied and pasted within a named range, the end of that range will be modified (decremented in all the examples I have seen) when it should be unchanged. For example, "Tasks" is defined as $Sheet1.$B$2:$B$59. B49:B53 is then copied and the values (Text, Numbers, Date & Time) pasted to B30 and following cells. The named range "Tasks" is now found to be $Sheet1.$B$2:$B$40 when it should be unchanged. Regards. David Lochrin
Please attach a simple document demonstrating the issue. Marking as NEEDINFO - once you attach set to UNCONFIRMED. Thanks
Created attachment 117689 [details] A spreadsheet which demonstrates the problem
Created attachment 117690 [details] The macro called by the button (not relevant to problem)
Sorry, but I hadn't noticed Joel's request to change the status when I posted the problem example.
Reproducible with Version: 5.1.0.0.alpha1+ Build ID: 6b7354ae66db40246a09e00aa876443057655a43 TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-08-19_01:05:16
I'm trying to stab this..
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7d267d3b168ba3b13763733e8c319a79d990773a Resolves: tdf#93127 copying cells does not modify named expressions It will be available in 5.2.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.
Pending review https://gerrit.libreoffice.org/23409 for 5-1
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c4af2adea07fe87a0d785f413fd8cc4b1adc5e33 unit test for copying cells within named range, tdf#93127 It will be available in 5.2.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-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5e655ecfe007238080941077c6dc6187005e91fa&h=libreoffice-5-1 Resolves: tdf#93127 copying cells does not modify named expressions It will be available in 5.1.3. 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.
*** Bug 91744 has been marked as a duplicate of this bug. ***