Created attachment 136679 [details]
Screenshot of MS Word 2013 "Insert copied cells..." command in context menu
Add commands to Calc that combine
* "Paste" and the paste special option "Shift cells down" (at rows and a single cell) and
* "Paste" and the paste special option "Shift cells right" (at rows, columns and a single cell)
so that you can use it in context menus, menus, toolbars and for keyboard shortcuts.
Standard paste option doesn't shift any cell but in my experience in existing spreadsheets cells often will not be pasted to replace but to add cells/rows/columns and nothing should be overwritten. To make this possible now you have to work with the paste special dialog or with macros which both are not user-friendly solutions.
In MSO Excel this is called "Insert copied cells..." (translation done by me, I only know the German term "Kopierte Zellen einfügen..." for it) and it is the standard option when pasting cells over other cells regardless whether the target cells have content or not.
I find this very useful in MSO Excel--but only additionally to the normal paste command and not replacing it because it's inconvenient to paste and overwrite cells in MSO Excel similar to them that it's inconvenient to paste cells in Calc now if you don't want to overwrite existing cells.
As follow-up bugs I would also suggest to
* add these commands to Calc's context menus when right-clicking on cells, row headers and column headers,
* add such commands to Writer tables.
But that would need additional bug reports after fixing this enhancement request.
*** This bug has been marked as a duplicate of bug 39936 ***