Select a line, then cut it and paste it somewhere else.
The line selected for cut goes blank but isn't removed.
The line selected for cut should be removed since it's a cut that is performed.
The cut & paste works on the contents of the cells. It is the way Calc works for ages. For me it is not a bug as it works as designed.
Best regards. JBF
I understand but if that design can be improved I don't see any good reason not to change it.
Main reasons why it's not good are :
1/ It's a waste of time every time a cut/paste is performed. Cut is supposed to cut, not copy and wipe cells.
2/ For the end user it is a regression compared to what they are used to.
3/ Cut/paste function is one of the most frequently used functions in a spreadsheet.
I'm currently leading a small scale test with 95 regular users -not IT- out of 5000 users and almost everybody reported this problem as upsetting.
This design is obviously a problem to many if not all the calc users.
Is there a way to proceed so that this design is reconsidered as it would be a significant usability improvement?
I'm discovering how the community is structured, it's the first time I'm contributing to an opensource project, all of this is quite new for me.
I'll get in touch with the design team about this feature, the bugtracker isn't the good place for this kind of discussion,
Sorry for the inconvenience, this is not a bug,
I agree. Maybe a new design should be proposed? See <http://wiki.documentfoundation.org/Design>.
The feature (move a line) already exists:
1. Select the line (click on the header)
2. Move the cursor on the line (not on the header) and move the selection to the destination by pressing the Alt key
Agree that this is not terribly logical & agree with Eric's (bureautiquelibre's) proposed solution.
One of the caveats here is presumably making sure that formulae stay intact, even as a line is removed* – so I guess this improvement might be some work...
* Simple example: you have a formula SUM(A1:A4) in cell A5 and then delete row 3. The formula will now be in A4... to make sure the formula is still valid, you'd have to correct it to SUM(A1:A3).
Disregard the last part of my comment. I should have tried what happen when removing a row currently – and formulas are corrected as expected. So, I don't really see any reason not do this.
(Setting major => normal, because while annoying, it's not related to data loss etc.)
Adding keyword needsUXeval to see if a change is still a valid/wanted issue.
Do you mean do have something like
A B C
1 x x x
2 y y y
3 z z z
and on cut and paste of row 2 to 4 all z-values are moved into row 2? That actually happens when you press Alt once the dragging has started. It's the same behavior as known from Microsoft products. Would be good to have a keyboard shortcut like or option in the paste special dialog.
A specific option in the paste special would do the job (that's the way recent MSO versions do it)
The origin of this request was from MSO2003 users where cut/paste removes the whole line when paste command is performed.
Newer version behave differently indeed.
I'll attend todays design meeting, maybe we can talk about this,
It seems to me that this bug is very much related to bug 39936, as "paste + shift cells in one click" also suffers from this behavior in Calc on Cut&Paste.
Therefore, I added bug 39936 under "see also".
Closing as a duplicate as a longer discussion has happened in bug 99483.
*** This bug has been marked as a duplicate of bug 99483 ***