[Libreoffice-bugs] [Bug 112814] New: Add commands that combine "Paste" and option " Shift cells"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112814

            Bug ID: 112814
           Summary: Add commands that combine "Paste" and option "Shift
                    cells"
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: thomas.lendo at gmail.com

Created attachment 136679
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136679&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171002/6a771b0c/attachment.html>