Steps to reproduce (on Windows): - Open a new Calc document - In any column, enter anything in six different cells - While holding the Ctrl-key, select some of those cells - Press Ctrl+C and paste this into any text editor Result: Only the cell with the lowest row number will have been copied. Related tests: - Copying multiple cells within one row works as expected - Trying to copy cells from different rows/columns gives "This function cannot be applied to a multiple selection" (translated from the German text I get) I first noticed this problem with 5.0.0.5 (x86). Problem persists with 5.0.3.2 (x64). Windows 7, SP1.
I can confirm with Version: 5.1.0.0.alpha1+ (x64) Build ID: b35e797ca0e2c7e7ad6dbccea6b92208b209677c TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-11-02_22:21:21 and Verze: 4.1.5.3 ID sestavení: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20161108
Still the very same problem as in my initial report. LibreOffice 5.1.6.2 (x64) Windows 10 (1607), 64-bit
I repro, but the cell with the highest row number is pasted. Version: 6.1.0.0.alpha0+ Build ID: 104b26b246c94c8c66864b20d00e419d96b15961 CPU threads: 4; OS: Windows 10.0; UI render: default; TinderBox: Win-x86@39, Branch:master, Time: 2018-04-16_08:30:15 Locale: fi-FI (fi_FI); Calc: group
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Bug no longer present in... LibreOffice 6.1.5.2 (x64) Windows 10 (1809), 64-bit Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; Gebietsschema: de-DE (de_DE); Calc: group threaded
(In reply to Larsen from comment #6) > Bug no longer present in... > > LibreOffice 6.1.5.2 (x64) > Windows 10 (1809), 64-bit > > Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 > CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; > Gebietsschema: de-DE (de_DE); Calc: group threaded Bug still present in Arch Linux 64-bit Version: 6.3.0.0.alpha0+ Build ID: b8f33d053c2cbf05872cf9ddfeff4cc302ee281f CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded Built on 20 April 2019 and also 3.3.0
Dear Larsen, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still reproducible in Version: 7.1.1.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 4; OS: Linux 5.3; UI render: GL; VCL: kf5 Locale: de-CH (en_US.UTF-8); UI: de-DE Calc: threaded and Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 1c1226709c6be39c5462f5e6e1262ca630b30b34 CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: x11 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded The cell with the highest row number is pasted, or more if they were consecutive, but not others
I've found the problem.
I've submitted a patch: https://gerrit.libreoffice.org/c/core/+/114534 Waiting for review I think the behavior to copying to system clipboard is still not correct. I created bug 141847.
scito committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/7c1e22152ed1a1837782a55fc9997f8e7801681b tdf#95554 fix ScDocument::GetClipArea() for rows: use > instead of < 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.
Verified, thanks Arch Linux 64-bit Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 3199182588fecac8a1c1fe202ca55702a3aab6ab CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 23 April 2021
scito committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/06d5d625e1dc8489e51b962353ac423669e61fed tdf#95554 fix ScDocument::GetClipArea() for rows: use > instead of < It will be available in 7.1.4. 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.
First problem looks good in 7.1.4.0.0+ (x64). Should I open a separate bug report for the related problem (see above)?
(In reply to Larsen from comment #15) > First problem looks good in 7.1.4.0.0+ (x64). > > Should I open a separate bug report for the related problem (see above)? I don't know what related problem you are referring to (too vague), but please do.
'Trying to copy cells from different rows/columns gives "This function cannot be applied to a multiple selection"' Ok, see bug 141907.
shubham656 committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/44a783185e09dc7da374a556fad44bddf1c8a1ce tdf#95554 Add UITest It will be available in 7.3.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.
Almost ok, but there are gaps from the not selected cells when pasting into text editor. On the other hand, when I paste into the same spreadsheet, the gaps are removed. IMHO this should be the other way round: - No gaps when pasting into text editor - Retain gaps when pasting into spreadsheet