Description: When I try to copy a row with a form control (check box) that is anchored to a cell to multiple selected rows the form control is only inserted once and the size of the form control is changed. Steps to Reproduce: 1. Insert a check box form control on a new spreadsheet 2. Reduce height so to fit in a row 3. Move the check box to the cell A1 4. Disable design mode 5. Mark the first row and right click it then select copy 6. Mark rows 2 to 5 and right click then select insert Actual Results: In LibreOffice 5.4 no check box is inserted, in version 6.1 and 6.2 only one is inserted and the size of the inserted is wrong (when clicking in design mode you can see that the height has grown) Expected Results: Four check boxes should be inserted in rows 2 to 5 with the same size as the original Reproducible: Always User Profile Reset: No Additional Info: Tested first with version 5.4.7 (64 Bit) then with a new installation of version 6.0.7 (32 Bit) on another system and then also with new installations of versions 6.1.3 an 6.2.0.0alpha1 (both 32 Bit). If you mark two rows (version 5.4) or three rows (version 6.1) with the check box for copy the insert works but in version 6.1 the size is wrong for some of the inserted check boxes and when i tried to insert to ten rows the check box was inserted to eleven rows.
Please attach a sample document that gets us through step 4 as that seems pretty simple to do. Our team is way too small to create sample documents for features that we're way less familiar with than you are. Set to UNCONFIRMED once attachment is made. Thanks! If you wish to help more please test against version 3.3 ("inherited from OOo) to find out if this is a regression: https://downloadarchive.documentfoundation.org/libreoffice/old/
Created attachment 146821 [details] Test file for Bugs 121443 and 121446.
Attached Test file. Included reference values in form control to show usage.
Tested with LibreOffice 3.3. Here the bug is not present.
Tested older versions of LibreOffice: In version 4.3.7.2 the bug is not present. In version 4.4.0.1 the bug is present. So version 4.4.0.1 introduced the bug.
This seems to have begun at the below commit. Adding Cc: to Kohei Yoshida ; Could you possibly take a look at this one? Thanks 41597bab6e54abeafeca5130c60a064bf7b7f72d is the first bad commit commit 41597bab6e54abeafeca5130c60a064bf7b7f72d Author: Matthew Francis <mjay.francis@gmail.com> Date: Sun Mar 15 06:03:44 2015 +0800 source-hash-ff5aad0a26aac46a3a540ac6ed2b7eca4a8cd23d commit ff5aad0a26aac46a3a540ac6ed2b7eca4a8cd23d Author: Kohei Yoshida <kohei.yoshida@collabora.com> AuthorDate: Mon Nov 10 18:45:21 2014 -0500 Commit: Kohei Yoshida <kohei.yoshida@collabora.com> CommitDate: Tue Nov 18 08:31:53 2014 -0500 Speed up pasting of single row onto multiple destination rows. This is an extension of the earlier paste optimization of a single cell across multiple destination cells. bibisect-44max
Dear ., 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
Tested with LibreOffice 6.2.8. The bug is still present.
Dear ., 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://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Tested with LibreOffice 7.1.7. The bug is still present.
Tested with LibreOffice 7.2.3. The bug is still present.
Created attachment 176545 [details] Test File for bugs 121443 and 121446 (how result should be)
Tested with OpenOffice 4.1.11. Here the bug is not present.
I used LO 3.5 to copy/paste A1 to A2:A5. Yes, each destination cell got a checkbox, but they are all tied together. I.E. if you uncheck one, they all uncheck. I assume the same is true for OpenOffice. Well, that is pointless, but I guess the bug itself still stands and likely applies to other controls etc (although I couldn't reproduce with a textbox - which didn't copy at all).
Tested with LibreOffice 7.5.5. The bug is still there.
Created attachment 191310 [details] sample ODS with shapes, form control buttons and raster images I used the linux-64-releases bibisect repository to compare libreoffice-4.3.7.1 to libreoffice-4.4.0.0.beta1. With the sample document: 1. Copy row 3 (which contains shapes, form controls and images) 2. Paste it to a single row 3. Paste it to several rows (same can be tested with a cell range instead) Results: * libreoffice-4.3.7.1: shape and form control (that are smaller than the cell) are pasted to the range. * libreoffice-4.4.0.0.beta1: nothing pasted anymore. So I am expanding the scope of this report to more than form controls, and upping the priority as it's a regression that affects basic copy-paste operations (see for example bug 158273 comment 1). Regardless of what settings the duplicate form controls have, objects anchored to cell should be copied and duplicated when copy-pasting (or even filling down, but this enhancement is not part of the regression and should be tracked separately). How things changed since then: * libreoffice-6.1.0.0.alpha1: paste works again (including images, and objects fitted to cell), but pasting to several rows changes the size of the objects instead of duplicating them * LO 7.6: objects are not stretched anymore, but there's only one copy in first row. That was Regina's fix dfb0d118f6b23730bc632885eb4703a37eeaec16 for bug 139083. We still need to restore the ability to duplicate objects anchored to cell when pasting to a range bigger than the source, just like cell data and formatting are.