[users] Cut/Paste Rows in Calc

2008-03-11 Thread Mike Field
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

Re: [users] Cut/Paste Rows in Calc

2008-03-11 Thread [EMAIL PROTECTED]
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

Re: [users] Cut/Paste Rows in Calc

2008-03-11 Thread Cor Nouws
Hi Neil, [EMAIL PROTECTED] wrote (11-3-2008 23:52) 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 o

Re: [users] Cut/Paste Rows in Calc

2008-03-11 Thread Harold Fuchs
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 bee

Re: [users] Cut/Paste Rows in Calc

2008-03-12 Thread Mike Field
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

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread Anthony Chilco
Mike Field wrote: Harold Fuchs wrote: 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 col

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread Anthony Chilco
Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: 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

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread Harold Fuchs
On 13/03/2008 14:54, Anthony Chilco wrote: Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: 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

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread Mike Field
Harold Fuchs wrote: On 13/03/2008 14:54, Anthony Chilco wrote: Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: 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,

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread TomW
Mike Field wrote: Harold Fuchs wrote: On 13/03/2008 14:54, Anthony Chilco wrote: Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: 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 tr

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread TomW
TomW wrote: Mike Field wrote: Harold Fuchs wrote: On 13/03/2008 14:54, Anthony Chilco wrote: Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: 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

Re: [users] Cut/Paste Rows in Calc

2008-03-13 Thread Harold Fuchs
On 13/03/2008 18:36, Mike Field wrote: Harold Fuchs wrote: On 13/03/2008 14:54, Anthony Chilco wrote: Anthony Chilco wrote: Mike Field wrote: Harold Fuchs wrote: Hi Harold, I'm using OpenOffice 2.3.1 under Windows Vista Business. I tried to use the Paste-Special-with-shift-cells i