Regina Henschel писал 2011-08-08 21:39:
Hi,
grfried schrieb:
It is not clear to me why "Insert Cut Cells" following a previous Cut
and
"Insert Copied Cells" following a previous Copy are not available in
the
right-click menu in LibreOffice Calc as they are in Microsoft Excel. I
use
them very frequently to re-order a set range of rows where sort is not
appropriate.
You do it different in LibO:
For cut&paste:
(1) Mark the row or column to move.
(2) Hold down the Alt-key and drag. You will notice a bold horizontal
line. If you have marked a whole row or column, do not try to use the
header, but use a cell.
(3) Drop when the line is there, where you want to insert the row or
column.
For copy&paste hold down Alt-Key and Ctrl-Key.
Thank you very much for this method.
It allows to overcome missing "insert cut cell feature" ("paste special"
do not replace it as it leaves unneeded empty cells).
But is was hard to understand - when dragging multiple lines insert
position depends on which line was "dragged" - if I drag first line
everything OK but if I drag second line, block inserts above line that
is above cursor itself - and it looks odd.
Cut behavior of LO itsef is semi-microsoft, semi-classic - data is gone
to clipboard disappearing from sheet, but flowing rectangle around empty
cells remains on screen for unclear purpose (in MS Office it means that
data is cut, what it means in LO I cannot guess).
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
- Re: [libreoffice-users] Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus · sergey
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.