Wendy Howard wrote:
I'm running Windows XP Pro and OOo 2.1
Is there a one-step equivalent in Calc to Excel's "Insert Cut Cells"
after one has "Cut" a row? I can't see how to do it without taking the
extra steps of (1) inserting a new row before pasting the contents into
it and (2) deleting the old row.
Have been a subscriber to this list for a couple of weeks now, and have
learned a lot. Hoping someone can add to that knowledge now, on
something that has been puzzling me for a while. :-)
Kind Regards,
Wendy Howard
Kaiwaka, New Zealand
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I find the behavior of OO Calc very odd when trying to insert a row (or
column) of data. One can 'Copy' a row, and using a PasteSpecial option,
insert the row. But if one 'Cuts' the row, PasteSpecial only allows you
to 'overwrite' or 'shift right'. With cutting an entire row, this will
fail. Cutting a column behaves the same. It gets even stranger. If
you take your 'Cut' row and 'Paste' it to some row, you then can use the
'PasteSpecial' option to insert a row with the proper shift.
Trying to insert a 'cut' column will only allow a 'shift down' in
'PasteSpecial.
Trying to insert cells behaves similarly.
It is like the default row or column 'insert' movements are reversed.
TomW
WinXP SP2 OO 2.1
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
