[libreoffice-users] Re: Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to Right-Click Menus

Here is the explanation for "insert cut cells" and "insert copied cells" as you requested.

If I cut a range of cells (usually one or more rows or columns), select a similarly shaped range of 
cells (again usually one or more row or columns), the cut cells are inserted at the selection and 
the cut region is deleted. So if I select row 10, right-click on it, then select row 20, 
right-click and select "Insert Cut cells", row 10 is deleted, rows 11 through 19 are shifted up one 
row, and the deleted row is inserted in front of row 20. "Insert Copied Cells" works similarly, 
except the original row is not deleted and rows 11 through 19 are not moved up to fill the gap. 
Instead a new row is insert in front of row 20 and the copied row pasted into row 20.

I have assumed that both OpenOffice and LibreOffice intened to do more than just be a data file 
compatible mimic of Microsoft Office 2003. There should be more to LibreOffice than just partial 
mimicry. If features like I have just described are not in LibreOffice Calc and also not in its 
macro capability then MS Excel files won't be read and executed properly in Calc. That would be a 
shame. I believe that the future of LibreOffice is in freezing the constant changing, but not 
improving, behavior of Microsoft so that a product such as Calc can be stable and compatible over a 
period of decades or forever.

---- "Nuno J. Silva [via Document Foundation Mail Archive]" 
<ml-node+3233146-751127155-420255@n3.nabble.com> wrote: 
> On 2011-08-07, grfried wrote:
>
> > 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. Is this the right forum for posting requests for
> > features?
>
> I don't know what these Excel functions do (can you give us a quick
> explanation?). 
>
> If they're about not overwriting existing shells and /shift/ them
> instead, that feature exists, just pick "Paste Special..."  and you can
> select "Down" or "Right" in "Shift cells".
>
> Now I guess the issue is that this isn't as efficient as just hitting a
> couple keys or picking one item in the context menu, and that is a
> problem if you use this frequently.
>
> -- 
> Nuno J. Silva (aka njsg)
> gopher://sdf-eu.org/1/users/njsg
>
> -- 
> For unsubscribe instructions e-mail to: users+help@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
>
>
>
> _______________________________________________
> If you reply to this email, your message will be added to the discussion below:
> http://nabble.documentfoundation.org/Calc-Would-like-to-see-Insert-Cut-Cells-Insert-Copied-Cells-Added-to-Right-Click-Menus-tp3232931p3233146.html
>
> To unsubscribe from Calc - Would like to see "Insert Cut Cells" & "Insert Copied Cells" Added to 
> Right-Click Menus, visit 
> http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3232931&code=dGhyb3dhd2F5Z2ZAc2MucnIuY29tfDMyMzI5MzF8OTI3NjE0OTM2


--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Would-like-to-see-Insert-Cut-Cells-Insert-Copied-Cells-Added-to-Right-Click-Menus-tp3232931p3235401.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+help@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