[Libreoffice-bugs] [Bug 39936] UI: Right Click on Row/Column -> Insert Copied Cells... (paste + shift cells in one click)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #55 from zzz <pox_ox2 at yahoo.com> ---
Vote +1 for adding this feature.
To be clear:
(a)If user "Copy" then "Insert Copied Rows/Columns",
  the source lines remain.
(b)If user "Cut" then "Insert Copied Rows/Columns",
  the source lines are removed (completely removed, not just blanked.).
(c)both right-click menu commands, and keyboard shortcuts

The reason this feature is important is because the existing "insert blank
lines" method requires the operator to count the lines many times, which is
prone to mistakes and time consuming. For example, if you need to move several
columns, you would:
(1)count how many columns, say 61.
(2)write that down on paper.
(3)go to the destination, carefully count the planned insertion to select a
range of 61 columns.
(4)double check that you really inserted 61 (or more) blank columns, because if
there were only 60, that will be a disaster.
(5)memorize the data around the destination, to detect overruns, onto paper.
(6)cut (or copy) and paste the columns.
(7)scroll to the end of paste area and check whether you haven't made an
overrun or underrun.
And if you want to copy, instead of moving, then repeat step (3)-(7) for the
number of destinations you want to insert.

With this feature, the pasting part will become a matter of just 2 clicks, and
no mistakes.

Actually, I also want an extra feature that Excel doesn't have yet:
Give 2 choices of where to insert, agains the cell border.
(a)Insert Copied Rows/Columns before the border, ie. "I want to add this INTO
the tail of that table"
(b)Insert Copied Rows/Columns after the border, ie. "I want to move this right
below to but OUTSIDE of that table"
This affects
(1)Whether the existing border line graphics stay below the insertion, or above
it.
(2)Whether the cell formula range (such as sum() function, named variables,
sort/filter range etc.) should be extended or not.
I want this because currently I am wasting a significant time re-drawing the
border line for tables and checking/correcting broken sum() source ranges.

  > Xisco Faulí 2019-11-29 13:29:45 UTC
  >Changing priority back to 'medium' since the number of duplicates is lower
than 5

Appalling criteria.
I think we are expected to carefully research past reports to avoid duplicates,
so count of duplicates should never be taken as a measure of popularity.
Please don't do it again.

-- 
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/20200709/ff8d59e4/attachment.htm>