Bug 39936 - UI: Right Click on Row/Column -> Insert Copied Cells... (paste + shift cells in one click)
Summary: UI: Right Click on Row/Column -> Insert Copied Cells... (paste + shift cells ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: high enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: needsDevEval
: 50104 55544 65841 112814 117036 (view as bug list)
Depends on:
Blocks: UNO-Command-New Paste Cell-Management
  Show dependency treegraph
 
Reported: 2011-08-08 10:13 UTC by Tim Deaton
Modified: 2019-02-28 22:12 UTC (History)
17 users (show)

See Also:
Crash report or crash signature:


Attachments
Hwo To Presentation (469.61 KB, application/vnd.oasis.opendocument.presentation)
2012-10-16 08:15 UTC, Rainer Bielefeld Retired
Details
Paste Special not available on Linux (153.22 KB, image/png)
2012-10-16 20:05 UTC, Gerry
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Tim Deaton 2011-08-08 10:13:29 UTC
I just learned that LO can do these two things thru the "paste special" menu.

In Excel, I use "Insert Cut Cells" and "Insert Copied Cells" all the time, and that has been one big reason why I don't use OOo exclusively.  (I'm on OOo v3.3.0 on WinXP, and haven't felt comfortable about moving to LO yet.)

LO's process is:
select the new location and then | Edit | Paste Special | Shift Cells Down |

Excel includes these in their right-click menus:
right-click on the target cell or row, then click "Insert cut cells"
which replaces the normal "paste" entry in the context menu.  ("Insert Copied Cells" works the same way.)

I use this in Excel all the time.  It's VERY nice to know that LO can do this at all.  But PLEASE add it to the right-click menus.
Comment 1 m.a.riosv 2011-08-11 15:42:30 UTC
Also you can open the Toolbar Insert Cells. (Menu/View/Toolbars/Insert cells).
Comment 2 Rainer Bielefeld Retired 2011-09-21 10:04:11 UTC
No Master Bug, limitation has always been that way.
No Regression
Comment 3 Björn Michaelsen 2011-12-23 12:22:26 UTC Comment hidden (obsolete)
Comment 4 Florian Reisinger 2012-08-14 13:58:30 UTC Comment hidden (obsolete)
Comment 5 Florian Reisinger 2012-08-14 13:59:47 UTC Comment hidden (obsolete)
Comment 6 Florian Reisinger 2012-08-14 14:04:24 UTC Comment hidden (obsolete)
Comment 7 Florian Reisinger 2012-08-14 14:06:35 UTC Comment hidden (obsolete)
Comment 8 sasha.libreoffice 2012-10-04 12:49:25 UTC
Reopening because it is RFE
in 3.6.1 not implemented yet
In Excel 2003 is context menu item which opens dialog with variants:
- Insert with shifting columns rightwards
- Insert with shifting rows downwards
- Insert column
- Insert row

In Calc the same dialog resides in Insert->Cells and assigned on Ctrl-+ by default.
IMHO it is naturally to add it to context menu, because context menu is almost empty.
Comment 9 Joel Madero 2012-10-14 19:55:12 UTC
Confirming, marking as NEW and prioritizing as Enhancement - Medium. Probably useful for quite a few people, also easy to implement

Thanks for reporting
Comment 10 Gerry 2012-10-15 16:08:39 UTC Comment hidden (obsolete)
Comment 11 Joel Madero 2012-10-15 16:12:01 UTC Comment hidden (obsolete)
Comment 12 Joel Madero 2012-10-15 16:12:49 UTC
*** Bug 50104 has been marked as a duplicate of this bug. ***
Comment 13 Tim Deaton 2012-10-15 18:11:12 UTC
Thank you, Sasha and Joel, for re-opening this.  For whatever reason, I missed Florian's posts in my email.  I am now using LO 3.5.6.2 on Win7 (as well as Excel 2003 - depending on the project).  I really hope that this enhancement can be accomplished soon.
Comment 14 Rainer Bielefeld Retired 2012-10-16 07:22:27 UTC
The questions are:
1) What existing(?) function?
   (I do not know anything like "Insert Cut Cells")

do we want to 

2) add to what to what context menu? 
   (Why is "Paste" in context menu not enough? For me that works fine, I can
   select whether I want to overwrite or to shift existing contents)

Currently we have a "Make it look like in EXCEL" request, too imprecise for an easy fix and for NEW due to <https://wiki.documentfoundation.org/BugTriage#Process>  item 5

To be honest: I don't understand this request. Can somebody contribute a "real life problem" with a sample document and clear description what should be improved?
Comment 15 Gerry 2012-10-16 07:46:28 UTC
@Rainer: In the context menu, how can you "select whether I want to overwrite or to shift existing contents"? I have no option there in LibreOffice, but only "paste" which overwrites the content.
Comment 16 Rainer Bielefeld Retired 2012-10-16 08:15:12 UTC
Created attachment 68612 [details]
Hwo To Presentation

What's so bad with proceeding as shown in the HoTo?

@Gerry:
I asked for a real life example and got a "I don't know how to" comment ...
Comment 17 Gerry 2012-10-16 20:05:48 UTC
Created attachment 68644 [details]
Paste Special not available on Linux

Dear Rainer,

I think I now understand the confusion. Is it possible that this "Paste Special" feature is simply not available on Linux?

Please see the attached screenshot. LibreOffice only offers "Paste", but nothing else. Also, if I try to choose Edit -> Paste Special simply nothing happens.

Detailled description of the screenshot: I had following sheet:
a a 

System: Ubuntu 11.10, LibreOffice 3.5.4.2 Build ID: 350m1(Build:2) PPA.
Comment 18 Joel Madero 2012-10-16 20:08:31 UTC
I also never get this prompt asking me if I want to shift cells. I only get the overwrite prompt which warns me that I'm about to overwrite stuff. 

Bodhi Linux
LibO:3.6.1.2
Comment 19 Gerry 2012-10-16 20:14:33 UTC
Sorry, I accidentally hit the Save button:

This is how my example sheet looked like:
a	a	a	a	a	a
a	a	a	a	a	a
a	a	a	a	a	a
c	c	c	c	c	c
c	c	c	c	c	c
c	c	c	c	c	c
b	b	b	b	b	b
b	b	b	b	b	b
b	b	b	b	b	b

However, I wanted to insert the "b"-rows before the "c"-rows so that the sheet looks like this:
a	a	a	a	a	a
a	a	a	a	a	a
a	a	a	a	a	a
b	b	b	b	b	b
b	b	b	b	b	b
b	b	b	b	b	b
c	c	c	c	c	c
c	c	c	c	c	c
c	c	c	c	c	c

In Linx there are only two possibilities to solve this issue:
(1) Mouse and click: Insert manually three empty rows before the "c"-rows and cut&paste the "b"-rows over these created empty rows.
(2) The people-who-search-for-shortcuts-approach: http://help.libreoffice.org/Calc/Moving_Cells_by_Drag-and-Drop To be honest, for very long time I did not know that this feature existed. 

I suggest that this Moving_Cells_by_Drag-and-Drop should be accessible by the context menu.
Comment 20 Rainer Bielefeld Retired 2012-10-17 05:45:35 UTC
This still is not NEW, we have several unclear observations.

So I think we should first do some research concerning the unavailable 'Paste Special', what would be a real bug.

For this new situation I should contribute a Step by step instruction for my  Attachment 2012-10-16 08:15 UTC to avoid any misunderstanding and to narrow down the problem.

Steps how to reproduce with parallel installation of Master "LOdev  3.7.0.0.alpha0+   -  ENGLISH UI / German Locale  [Build ID: 747ecb]"  {tinderbox: @16, pull time 2012-10-08 09:46:32} on German WIN7 Home Premium (64bit) with separate User Profile for Master Branch:

1. Launch LibO
2. Blank New Spreadsheet from LibO Start Center using "New Spreadsheet" Button
3. Type "1" into A1
4. Use Autofill to fill column until A16
6. Select A1:B7 using mouse
5. Use Autofill to fill rows A1:A16 until  column D as shown in screenshots
8. Right click B7
   > Context menu appears
9. 'Copy' 
10. Click C11
11. rigt Click C11
    > Context menu appears
12. Click 'Paste Special' in context menu
    Dialog appears  as shown in "How To Presentation"

I also can reproduce that correct behavior on Ubuntu 12.04 (VirtualBox) with LibO 3.5.4.2.


Now an other case what might be related to garrys screenshot.
Gerry's screen shot shows a completely different situation, he selected a complete row(?) and right clicked on a row header(!). As the name "context menu" says the contents of that menu is context sensitive and so we have to investigate every context separately.

I can't reproduce Gerry's observation with a.m. Ubuntu LibO and a proceeding a little different from Gerris proceeding:

11. Launch LibO Spreas sheet from Application selector
12. do nothing
13. Type "1" into A1
14. Use Autofill to fill column until A16
16. Select A1:B7 using mouse
15. Use Autofill to fill rows A1:A16 until  column D as shown in screenshots
16. Click on Page Heading "7"
    > Row becomes selected
17. Right Click on Page Heading 7
18. In context menu click 'Copy'
19. Right Click on Page Heading 7
20. In context menu click 'Paste Special'
    Dialog appears  as shown in "How To Presentation"
21. Paste special with "Shift Cells down" 
    will work as expected, shifts rows including selecte one down
     and pastes clipboard to so created empty row


I CAN  reproduce Gerry's observation with a.m. Ubuntu LibO and a proceeding similar to what might have been Gerry's. I did not try to follow exactly  Gerry's proceeding, because screenshot seems to show that He copied empty cells A12:F20, and "Paste Nothing" seems not to be a very interesting case

31. Launch LibO Spreas sheet from Application selector
32. do nothing
33. Type "1" into A1
34. Use Autofill to fill column until A16
36. Select A1:B7 using mouse
35. Use Autofill to fill rows A1:A16 until  column D as shown in screenshots
36. Select C13:D16 using Mouse
    > Range becomes highlighted
37. Right Click D16
38. In context menu click 'Copy'
39. Right Click on Page Heading 7
    Context menu WITHOUT paste special appears
That looks like bug in context menu, BUT althoug Paste special exists and seem active in menu 'Edit', it will do nothing.

WIN LibO 3.5.2 won't even offer a paste function in Context menu for this case, Master 3.7.0 works fine, offers Paste special and shifts cells

But now I understand that I was wrong concerning Gerry's intentions, I believe He wanted to cut and paste, and screenshot shows cut contents? 

New test 

41. Create spreadsheet as whon in Gerry's ASCII art
42. Select all "b" (but not the complete rows)
43. rightclick last "b" (bottom right)
44. click 'Cut' in contxt menu
    all "b" disappear
45. Click row heading of first "c" row (what, BTW, is wrong, a paste will fill
    all the clumns of the row(s) with "b" and not only as many columns as 
    were filled with "b" in step 42
46. right click row heading of first "c" row
    Indeed, Context menu does not contain paste special.
Menu 'Edit -> Paste special' here shows the same problem as described after step 39, does not work.
Paste from context menu will work as expected, overwrite all "c" and fill lines completely until end with "b"
WIN LibO 3.5.6.2 in step 46 does not offer a paste at all
    
Results in step 46 with parallel installation of Master "LOdev  3.7.0.0.alpha0+:
Paste Special will be offered, dialog only allows "don't shift" and "shift right", I can't understand why "shift down is not allowed", and "shift right" is nonsense, can not be done, I will submit a separate bug for this.  'Don't shift' and 'Shift Right' work fine.
Menu 'Edit -> Paste Special' works the same way as context menu.
Same results with LibO 3.6.3.1

So the question for now is:
Can you confirm that the "Step 46 problem" is fixed for LibO 3.6.3.1 and 3.7.0 under Linux (as i see it for WIN)?

Please excuse me for long comment, but I think it's necessary to figure out what exactly the remaining problem is.
Comment 21 Tim Deaton 2012-10-17 21:45:47 UTC
It appears that because Gerry had a different problem, and because Rainer could not understand (?) my original request, that this "bug report" has now been diverted to deal with something else.

Now I am confused.  

Unless someone with authority restores the original focus of this request, then I guess I'll take my original enhancement request and create a new bug report.
Comment 22 Joel Madero 2012-10-17 21:48:08 UTC
Rainer, I think you got to the root of the problem.

From my understanding user is asking for us to include a separate paste option that is for "don't overwrite" similar to how Excel does it. Paste special isn't intuitive for a user to think of when they are pasting something (this usually is for pasting only numbers, or only formats, etc...). Excel has an option called "insert copied cells", where this is "paste while shifting" and then a regular paste which is "overwrite"

This is when we select a column or row to cut and then paste somewhere else

If I'm understanding this correct, I still see it as a valid request even if it the functionality is already available by going to paste-special

@Tim - don't open a new bug, Rainer is one of our leading QA people ;) Just need to figure out the exact request, let us know if I was correct in my summary above
Comment 23 Tim Deaton 2012-10-18 02:38:01 UTC
Thank you, Joel, and yes, what you said is accurate.

To try and be more detailed and easier to understand:

In Excel, when you point to a cell, range, row, or column and right-click for the context menu, you normally see "Insert" as one of the options.  Choosing that will insert a blank row, column, or cell as appropriate, moving the existing existing data down or to the right.

However, when you choose to "cut" or "copy" a cell, range, row(s), or column(s), and then right-click on a destination cell, range, row, or column, THEN instead of "Insert", you see "Insert Cut Cells" (or "Insert Copy Cells").

Choosing "Insert Cut Cells" will delete the source cell, range, row(s), or column(s) from its original location and insert it into the destination location.  All cells between the original and the destination locations will move to make room for the source cells at the destination and to fill the gap created at the original location.

Choosing "Insert Copied Cells" will work similarly without deleting the source cells.  If it's rows being copied, the existing row at the destination gets moved down; if columns, the existing column at the destination is moved to the right.  If it's a cell or range being copied, you are asked whether to move existing cells down or to the right.

That is what I would like to see in LO.
Comment 24 Joel Madero 2012-10-18 05:16:09 UTC
Rainer I'd like to mark this as NEW again, can you confirm that this is a valid request? Basically just to add the option inside of the dialog that comes up upon right click instead of having to go to paste special. 

What it looks like in excel:

http://imgsrv.worldstart.com/mso-images/insert-copied-cells.gif
Comment 25 Rainer Bielefeld Retired 2012-12-21 06:53:48 UTC
To be honest, I lost overview here. What do you think about closing this bug here, to open new separate bugs concerning the fond bugs and valid enhancement requests (if appropriate, with links to relevant comments in this Bug)?
Comment 26 Joel Madero 2013-01-29 19:22:47 UTC
Rainer - I prefer just editing the title here and marking as NEW. I think all the other stuff said, if someone else wants to open separate bugs that's fine but the root of this particular enhancement request is "Insert -> Insert Copied Cells..." which I think is completely valid.

Marking as such, Rainer, hope this works out :)
Comment 27 Joel Madero 2013-05-30 17:59:14 UTC
*** Bug 55544 has been marked as a duplicate of this bug. ***
Comment 28 Dan Dascalescu 2013-06-28 19:10:19 UTC
I'm not sure what's so difficult about this bug. LibreCalc just needs to implement the "Insert cut cells" context menu option from Excel.

Here's a screencast of a "real life problem": http://screencast.com/t/S5jtL4bz

(by the way, a screencast is worth a thousand words)
Comment 29 Joel Madero 2013-06-28 19:35:52 UTC
Well the code is there for anyone to poke at - feel free to do it if it's easy to do.

Our devs are working on some serious bugs -- some of which take days of experienced developer time and are critical for everyone, not just a convenient enhancement.

Another option is to of course pay someone to poke at the code - again it's all out there free and ready to be hacked
Comment 30 tommy27 2013-06-29 11:10:49 UTC
(In reply to comment #28)
> I'm not sure what's so difficult about this bug. LibreCalc just needs to
> implement the "Insert cut cells" context menu option from Excel.
> 
> Here's a screencast of a "real life problem":
> http://screencast.com/t/S5jtL4bz
> 
> (by the way, a screencast is worth a thousand words)

the screencast is very useful to understand what the enhancement request is about.
I agree that doing the same thing in Excel is much easier.

after saying that, I agree with Joel, if you have coding skills try doing it yourself... if you don't have, make a donation to LibO or hire a developer...

it worked for me..
https://bugs.freedesktop.org/show_bug.cgi?id=48729#c4
Comment 31 ign_christian 2013-09-27 02:04:59 UTC
*** Bug 65841 has been marked as a duplicate of this bug. ***
Comment 32 Pedro 2014-02-27 21:33:34 UTC
This would be a nice addition to Calc's functionality. As a spreadsheet user this is one function that I use on a daily basis. 

I always assumed this was asking too much from Calc. From the comments below it seems to be an Easy Hack... Can't it be included in some GSOC task?
Comment 33 Joel Madero 2014-02-27 22:55:16 UTC
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.

Thank you and apologies for the noise
Comment 34 Charles 2014-02-28 12:26:07 UTC
I was just pointed to this bug after *years* of minor frustration at having to do the - insert new target row/columns, cut source row/columns, paste to the new blank target row/columns, delete original source columns - dance, I finally decided to ask for help on the users list, and after a short time, discovered that I had been totally missing BOTH the 'Paste Special' method, and much better, the ability to MOVE rows and columns using drag-n-drop, just as you can groups of selected cells (which I already knew about, and used a lot).

So, here are some points I'd like to make...

1. Anyone coming from Excel trying out Libreoffice (or Openoffice), who encounters this issue, will definitely declare this a problem, the severity determined by how often they use it - the more they use the Excel feature, the more serious the problem will appear to them.

2. The Help text that describes moving cells, does not mention anywhere that this also applies to entire rows and columns.

The Help documentation definitely needs to be updated. I will file a bug/enhancement for that in a bit, along with some suggested new text.

It simply never occurred to me to click (grab) down in the CONTENT after selecting a row or column. I must say it was a major revelation, followed by wailing and gnashing of teeth at the many years I have missed something so blatantly obvious (hindsight and all), floundering with the above roundabout way.

And since I, a SysAdmin, been doing I.T. related stuff, including end-user support for things like this and who considers himself very technically inclined, never figured this out myself using the Help or Google, and only did so after asking on the list (admittedly I should have done that years ago, but the fact is I didn't do this dance all that often, which is why I termed it a source of 'minor frustration' for me)), I venture to guess that most others would never discover the drag-n-drop method (which indeed is very cool!), and would be just one more potential user who tried Libreoffice and left in frustration.

I'm not saying Libreoffice should try to emulate every single Excel feature, but the ones that are very useful, and may not be too much work, should absolutely be considered.

3. The 'Paste Special' still leaves the source row/columns in place.

I consider this a bug. If you CUT an entire row/column, it should CUT the entire row/column, not just the content in the cells in the row/column.

Does anyone know if there is already a bug open for that? If not I'll open one later, when I enter the bug for updating the documentation.

4. I really like the new (to me) graphical drag-n-drop method, but for most cases I think the Excel way is quicker and what I'd prefer to use - just select the row/columns you want to move, right-click > Cut[Copy], then "right-click > Insert Cut[Copied] Row(s)[Column(s)" on the row/column header above/to-the-left-of which you want to insert the Cut[Copied] row/columns.

Note: Excel options are labeled 'Insert Cut[Copied] Cells', regardless of if you cut/copied a group of cells, or entire row/columns.

I think this is wrong. Libreoffice, if this is implemented, should distinguish between 'cells', and entire row/columns. If the user cut just a group of selected cells within a sheet, then the choice should say 'Cells', but if they selected entire row/columns, then the choice should reflect that as 'Rows' (or 'Columns').

I think if Libreoffice implemented both ways, and documented these properly, it would be yet another way that it can be considered superior to MSO...
Comment 35 Charles 2014-02-28 15:15:36 UTC
Documentation enhancement bug 75609 opened...
Comment 36 Dan Dascalescu 2015-03-04 08:31:23 UTC
How do I donate to have this done?

I really don't have time to poke through the massive codebase, but all the pieces are there:

* the Paste Special + Shift cells down functionality
* keyboard handling to intercept Ctrl+Shift++/= (control shift plus/equals)

When done, I can't imagine the patch will be more complicated than 10 lines of code. If it is, that suggests a need for refactoring the paste special functionality.
Comment 37 QA Administrators 2015-03-04 18:31:57 UTC
@Dan -

There is no direct "Pay for fixes" within TDF (we have no developers). Some have used freedomsponsors.org and then place the link in the bug itself.

The other option is paid support (outside of TDF) but I can guarantee that it'd be too expensive for such a minor task. Even thinking it'd take 5-10 hours to implement (finding the relevant code, patching it, testing it, submitting it) you're talking about several hundred dollars.

So - I suppose options are to bid on freedomsponsor (not supported by TDF in any ways), reach out to companies who offer support (probably very expensive) or possibly ping individual certified developers and ask for a quote: http://www.documentfoundation.org/certification/developers/
Comment 38 Gerry 2015-08-12 16:20:48 UTC
EasyHack? Doesn't this bug qualify as an EasyHack? It would be great if a developer could have a look at it.
Comment 39 Joel Madero 2015-08-12 17:21:22 UTC
needsDevEval (see whiteboard) is the equivalent of "proposed Easy Hack" - an easy hack requires an expert developer to give code pointers and be willing to mentor...it's not enough just to say "this looks easy."
Comment 40 Gerry 2015-08-12 17:56:12 UTC Comment hidden (obsolete)
Comment 41 Alvin Austin 2015-11-03 19:47:40 UTC
Hello, as an Excel and LibreOffice Calc user, I also want to reinforce the comments made earlier by these two gentlemen.  There is a real need for the "Insert Copied Cells" and "Insert Cut Cells" functionality in LibreOffice Calc, implemented as close as possible to the functionality of Excel.  Excel spreadsheet users use these functions all the time.

The usage is well described in these three comments.

Tim Deaton 2011-08-08 10:13:29 UTC
https://bugs.documentfoundation.org/show_bug.cgi?id=39936#c0

Tim Deaton 2012-10-18 02:38:01 UTC 
https://bugs.documentfoundation.org/show_bug.cgi?id=39936#c23

Charles 2014-02-28 12:26:07 UTC 
https://bugs.documentfoundation.org/show_bug.cgi?id=39936#c34

I can see from Google that this has been on the request list for a very long time.  It would be "just awesome" to see it finally incorporated into LibreOffice Calc, which is a great application in so many ways.

Thanks for keeping this feature enhancement request alive.
Comment 42 Robinson Tryon (qubit) 2015-12-13 11:21:28 UTC Comment hidden (obsolete)
Comment 43 Dan Dascalescu 2016-02-05 16:57:20 UTC Comment hidden (obsolete)
Comment 44 Joel Madero 2016-02-06 04:59:42 UTC
(In reply to Dan Dascalescu from comment #43)
> After a Windows crash, I gave LibreOffice, now at version 5, another chance.
> 
> However, the annoying ergonomics of moving a large group of cells via
> "select the new location and then | Edit | Paste Special | Shift Cells Down"
> prevents me from adopting LO.
> 

You don't have to go to the "edit" drop down - you can just right click and then go to "paste special"

As far as it being implemented....patches welcome ;)
Comment 45 Timur 2017-10-02 17:31:46 UTC
*** Bug 112814 has been marked as a duplicate of this bug. ***
Comment 46 Tim Deaton 2017-10-30 18:08:00 UTC Comment hidden (no-value)
Comment 47 Timur 2018-04-17 07:44:36 UTC
*** Bug 117036 has been marked as a duplicate of this bug. ***
Comment 48 Philip Ganchev 2018-04-28 10:10:28 UTC
+1

maybe we can start by writing a macro