Harold Fuchs wrote:
On 11/03/2008 22:09, 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)
I'm confused. In Calc, select the columns/rows and do Edit>Cut or
Ctrl-C. Move to the column/row which is to be the first of the new
data and select it (click in the column/row heading - not *your*
heading, Calc's: the A, B, C, ... for columns or 1, 2, 3, ... for
rows). Now do Edit>Paste or Ctrl-V. The data are moved. If you did
copy originally the data are copied. It just works. This in OpenOffice
2.2 on Win XP Pro.
If you want data to the right of /below the about-to-be-pasted data to
move to make way for that data, use Paste-Special and select the
relevant "shift cells" radio button shown bottom right of the pane.
Granted the cut operation only cuts the data, not the rows/columns so
that is one extra operation. If you like you can customise one of the
toolbars to display the Delete Columns button and/or Delete Rows
button. If you do this then you just click the relevant button after
cutting the data and while the columns/rows are still selected.
Hi Harold,
I'm using OpenOffice 2.3.1 under Windows Vista Business.
I tried to use the Paste-Special-with-shift-cells idea, but when I'm
trying to move a row, the "Shift Down" radio button is greyed out, and
conversely, when I'm trying to move a column, the "Shift Right" button
is greyed out.
This seems backwards - surely it's a bug?
If I ignore this and select the "inappropriate" shift-right when moving
a row, or shift-down when moving a column, I get a message saying
"Filled cells cannot be shifted beyond the sheet".
As you would expect, I guess.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
