Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


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


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.