Page 1 of 1

[Issue] Insert Cut Cells

Posted: Wed Jan 23, 2008 4:07 am
by Fahim
Hi
When i am using Excel i have an option that you can cut a cell and paste it through insert cut cells so that the existing cell will not be overwritten instead it will pushed down but i dont find such command in Calc can anybody can sort out this one Thanks in advance.

Re: Insert Cut Cells

Posted: Wed Jan 23, 2008 5:45 am
by acknak
Copy or Cut your cells, then:
Edit > Paste Special
  • Selection = "Paste All"
    Shift Cells = Shift up / Shift down

Re: Insert Cut Cells

Posted: Fri Feb 29, 2008 10:52 pm
by jmmen
Hi, I have done what acknak mention, but just has no shift and right shift option, down shift is dimmed. Do I miss something?

Re: Insert Cut Cells

Posted: Fri Feb 29, 2008 11:23 pm
by Villeroy
No, you don't miss anything. The developers miss something since many years and nobody noticed *and* reported the issue. I filed it in January 2008: http://www.openoffice.org/issues/show_bug.cgi?id=85187
Currently there is a drag&drop-feature under development. Until then you may use 4 of the CellMover macros for moving cells into 4 directions.

New link is Issue 21280 - Automatic Insert (shift down or shift right) of cells, columns, or rows when cut, or copied, and pasted. (Hagar, Moderator).

Re: Insert Cut Cells

Posted: Sun Mar 02, 2008 11:53 pm
by Hagar Delest
acknak wrote:Copy or Cut your cells
It works only if you copy a selection, not if you cut it.

NB: tagged the thread as Issue.

Re: [Issue] Insert Cut Cells

Posted: Tue Mar 04, 2008 4:27 pm
by AndrewZ

Re: [Issue] Insert Cut Cells

Posted: Tue Mar 04, 2008 9:57 pm
by Hagar Delest
But it doesn't work if you cut the selection.

The ALT key does the trick but it's not so obvious. BTW: you just need to hold the ALT key when you drop the selection.

Re: [Issue] Insert Cut Cells

Posted: Tue Mar 04, 2008 10:32 pm
by acknak
But it doesn't work if you cut the selection.
It does for me--in certain situations. Sometimes the "shift cells" option is there for a cut selection, sometimes it's not.

Moving cells around should be obvious, easy and dependable: it should "just work". I don't think we're quite there yet ;-)

Re: [Issue] Insert Cut Cells

Posted: Tue Mar 04, 2008 10:44 pm
by Hagar Delest
The shift option is there but not for the right direction: if I cut a column and want to paste special, I'm proposed the shift... Down option and the Right option is disabled (when it should be the only one allowed since I can't paste a column under another one).

Re: [Issue] Insert Cut Cells

Posted: Wed Mar 05, 2008 12:26 am
by acknak
Ahh, yes.. Now I see what you mean.

Re: [Issue] Insert Cut Cells

Posted: Tue Apr 01, 2008 7:00 pm
by jmmen
Downloaded 2.4, is seems like the same, no "down" shift.

Re: [Issue] Insert Cut Cells

Posted: Tue Apr 01, 2008 7:05 pm
by Villeroy
Drag&Drop with Alt-key.

Re: [Issue] Insert Cut Cells

Posted: Tue Apr 01, 2008 10:55 pm
by AndrewZ
The order in which you press keys is important, and to me, was anti-intuitive. You may want to watch the video demo of moving cells with drag and drop.

Re: [Issue] Insert Cut Cells

Posted: Wed Apr 02, 2008 7:04 am
by Weatherlawyer
A work around I use to gert the paste special option function when pasting from sheet to sheet or from writer to Calc is to copy to Notepad then on from there. It breaks the tied format, in some way clearing the decks as it were.

I hope someone comes up with the answer for the next release. 2.4 doesn't cut it -to coin a phrase.