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


2011/8/8 grfried <throwawaygf@sc.rr.com>:
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.

Then you can do it with LibreOffice and OpenOffice.org, but you need
to learn a new method for doing it. If not, you have three options (at
least) that I can think of:
1. Stick with Excel.
2. File a bug report (or rather a feature request).
3. Join the developer team and write a patch.

What you are asking for seems to be doable with Paste Special in
OpenOffice.org/LibreOffice, it just requires an extra mouse click (two
extra clicks the first time).


I have assumed that both OpenOffice and LibreOffice intened to do more than just be a data file 
compatible mimic of Microsoft Office 2003.

Either you or me totally missed the point there, I think. The file
compatibility (which is not complete and can never be) is, as I see
it, just a bonus, not the main feature of the whole project. If you
work with OpenOffice.org or LibreOffice, you are supposed to use the
Open Document Format and neither OpenOffice.org nor LibreOffice
intends to be a free version of MS Office.

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.

I don't think there is anything you can’t do with a macro, at least
simple tasks as the one this thread seems to be about, so if you think
the Paste Special method is too complicated you can always write a
macro for it or let someone else write one for you if you are lucky.

Fortunately LibreOffice did not copy MS Office’s behaviour in every
aspect. That's why there, for example, is no MS Excel leap-year bug in
LibreOffice, nor in OpenOffice.org (1900-02-29 doesn't exist in the
real world, in LibreOffice or in OpenOffice.org, but it does in MS
Excel, as far as I have heard).

Regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


---- "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



-- 
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

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.