Another nice feature that Excel has that Calc doesn't have with cut and
paste is this - in Excel you can copy (or cut) a cell (or range of
cells) and then move to the destination cell (or top left in the range)
and simply press enter instead of control-v (paste).
I also have to do things very differently when copying data from a
spreadsheet and then pasting into a table in a document. In Excel / Word
it pasted very nicely but in Calc / Writer it is complicated and ugly.
I am getting used to it.
I could go on about the things I am missing like the much more limited
range of keys available to assign shortcuts to and the inability to
assign buttons to many menu items (presumably macros could be written
but that is beyond my capabilities) and the inability to use page number
in a calculation in a footer.
The ease of use stuff that MS have put into their products almost tempts
me to go back but I don't think I will. I am hopeful that many of these
things will sort out with time.
Neil
Mike Field wrote:
Hi,
Excel has the ability to Cut one or more rows (or columns) and then
Insert Cut Rows (or Columns) at another position, thereby moving the
rows (or columns).
I haven't been able to find a way of doing the same thing in
OpenOffice Calc.
The best I've been able to do is Cut the rows (which just clears the
contents), delete the unwanted rows, Insert the correct number of rows
at the new position, then paste the contents into them.
That's four operations, where Excel can do it in two.
Does anyone know a quicker way of moving a range of rows (or columns)
to a new position?
I did see the recent reply to a similar question about tables in
Writer, but I'm talking about Calc.
Mike Field (UK)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]