Problem description: When you use the mouse (holding shift down or not) to copy fields downwards and the field is merged with more cells, this is transformed into one cell. So this operation behave different from CTRL+C and CTRL+V. Steps to reproduce: 1. Create an empty spreadsheet 2. Cell A1 .. C1 merged using icon for 'Merge and Center Cells' 3. Now drag this merged cell downwards. Current behavior: Only column a is filled out with text centered Expected behavior: Column A - C should be filled out as merged. Same as CTRL+C and CTRL+V Final comment: It might be from earlierversions as well, but I cannot check this at the moment.
Confirmed: Ubuntu 14.04 x 64 LibreOffice 4.4 built a few days ago & oldest version preBibisect - updating version New - confirmed Minor - slows down but doesn't prevent high quality work Low - default seems appropriate I see it was set to high - please don't update the importance/priority. We use a specific system that is objectively applied. Thanks for reporting!
Drag A1:C1 downwards does nothing for me, it is inactive. It works only if you drag A1:D1 that is at least one cell not merged right more. Tested with version 4.1.6, 4.2.6.3, 4.3.4.0.0+ and 4.4.0.0.alpha1+ under Ubuntu 14.04 x86-64 I think that merging cells is not a kind of formatting. Merging cells changes the structure of the sheet when formatting does not. Copy & paste is not intended to do the same as dragging downwards. Indeed when you drag a cell with a contents, other cells are filled with a contents updated (values incremented and formula updated) what it is not the case when you simply copy & paste (values not incremented). So, for me, the bug description does not match the current behavior of Calc. Please, could you explain further? Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. Best regards. JBF
Hi, This is my impression, that using the handle on a cell, a group of cells, found in the right lower corner should equal either create a serie or if you hold down CTRL copy the content. But I might be incorrect.
(In reply to p_kongstad from comment #3) > Hi, > > This is my impression, that using the handle on a cell, a group of cells, > found in the right lower corner should equal either create a serie or if you > hold down CTRL copy the content. But I might be incorrect. Did you check, on your own system, that dragging a merged cell is actually possible? Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #4) > (In reply to p_kongstad from comment #3) > > Hi, > > > > This is my impression, that using the handle on a cell, a group of cells, > > found in the right lower corner should equal either create a serie or if you > > hold down CTRL copy the content. But I might be incorrect. > > Did you check, on your own system, that dragging a merged cell is actually > possible? > > Best regards. JBF Yes, I can drag merged cells around in the spreadsheet. But that has nothing to do with copying and copy cell downwards using the dragging method (mouse).
I am not sure if we are speaking about the same thing. I try to reword: What I mean is that when I select the merged cells and place the mouse pointer on the black small square in the bottom right corner, the mouse pointer becomes a +, and, normally, if I hold down the left button of the mouse, I can drag downwards and the effect of this movement is to fill the cells below with its updated contents. What I say, is that, when I try to do that with a merged cell (like A1:C1 in your description), it does not work, it does nothing. Is it the same for you ? It works if I first drag right (to D1) then below. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #6) > I am not sure if we are speaking about the same thing. I try to reword: > What I mean is that when I select the merged cells and place the mouse > pointer on the black small square in the bottom right corner, the mouse > pointer becomes a +, and, normally, if I hold down the left button of the > mouse, I can drag downwards and the effect of this movement is to fill the > cells below with its updated contents. > What I say, is that, when I try to do that with a merged cell (like A1:C1 in > your description), it does not work, it does nothing. Is it the same for you > ? > It works if I first drag right (to D1) then below. > > Best regards. JBF Yes, it works for me as you describe, but you have to drag some rows downwards before the lines becomes visible and the merged cell becomes copied, but that is due to another bug I think. If it is 2 merged cells you have to drag downwards 5 or more. If 3 merged cells drag downwards 10 or more. Also non logical.
(In reply to p_kongstad from comment #7) > [...] > Yes, it works for me as you describe, but you have to drag some rows > downwards before the lines becomes visible and the merged cell becomes > copied, but that is due to another bug I think. Ok, I reproduce this behavior. I suggest you to open a new bug report for this particular behavior. From description: > Expected behavior: > > Column A - C should be filled out as merged. Same as CTRL+C and CTRL+V Why dragging should act as copy & paste? I think that merging cells is not a kind of formatting. Merging cells changes the structure of the sheet when formatting does not. As already written, copy & paste is not intended to do the same as dragging downwards. Indeed when you drag a cell with a contents, other cells are filled with this contents updated (values incremented and formula updated). It is not the case when you simply copy & paste, values are not incremented. For me it is not a bug but I may be wrong. Best regards. JBF
(In reply to Jean-Baptiste Faure from comment #8) > > Why dragging should act as copy & paste? > I think that merging cells is not a kind of formatting. Merging cells > changes the structure of the sheet when formatting does not. > As already written, copy & paste is not intended to do the same as dragging > downwards. Indeed when you drag a cell with a contents, other cells are > filled with this contents updated (values incremented and formula updated). > It is not the case when you simply copy & paste, values are not incremented. > > For me it is not a bug but I may be wrong. > > Best regards. JBF This is how other spreadsheets are working with merged cells and dragging them with the small rectangle. So I consider this as a bug. Maybe some one will bring other opinions to this issue. At the same time I upgrade from minor to normal.
Please do not mess around with the severity or importance. I already said that in my previous comment. By our definition this is a minor issue. I agree that it's a bug though - when I dragged I expected the format to continue and the format includes merging.
Also please respond directly in the report (not via email). It adds a bunch of stuff that just clutters the bug.
let's set status to NEW since the bug was confirmed by other users.
Bug present in Version: 4.3.4.1 Build ID: bc356b2f991740509f321d70e4512a6a54c5f243 Version: 4.4.0.0.alpha2+ Build ID: b7c4c78a097f76314982d8c1a9f2e58df95080a1
Still found in Version: 4.4.0.0.beta1 Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e Locale: en_US
** 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.0.4 or later) 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 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 your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
Bug still present in Version: 5.0.4.2 Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Locale: en-US (en_US.UTF-8)
Bug still present in Version: 5.1.0.2 Build ID: ecd3574d51754b043f865cf5bafee286d24db7cc CPU Threads: 2; OS Version: Linux 4.2; UI Render: default; Locale: en-US (en_US.UTF-8)
Bug still present in Version: 5.0.5.1 Build ID: 7609023f63524a6c8326f6c82e7e23f55a5b7bb5 Locale: en-US (en_US.UTF-8)
Bug still present in Version: 5.1.1.1 Build ID: c43cb650e9c145b181321ea547d38296db70f36e CPU Threads: 2; OS Version: Linux 4.2; UI Render: default; Locale: en-US (en_US.UTF-8)
This is still present in Version: 5.1.2.1 Build ID: 2603b69c5ec5981bb5f053f8ebfd1f3de00a4c29 CPU Threads: 2; OS Version: Linux 4.2; UI Render: default; Locale: en-US (en_US.UTF-8)
Bug still present in Version: 5.1.4.1 Build ID: a4d48e4ff0e9f93e78b6356ca7b0b6303e360356 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8)
Bug still present in Version: 5.2.0.1 Build ID: fcbcb4963bda8633ba72bd2108ca1e802aad557d CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8)
Bug still present Version: 5.2.1.1 Build ID: 2d75cf29e6d05e44c404f0547047f1da6563d380 CPU Threads: 2; OS Version: Linux 4.4; UI Render: default; Locale: en-US (en_US.UTF-8); Calc: group
[This is an automatic message] Changing version to 3.5.7.2 in order to get rid of 'preBibisect' version as 3.5.7.2 looks to be the last version not covered by bibisect-43all.
** 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.4.1 or 5.3.6 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-20170929
*** This bug has been marked as a duplicate of bug 59585 ***