2009/10/19 Tony Li <tony...@viscountchina.com> > Thanks, Harold, but when paste, that will overwrite the existing data.... > > Best Regards! > Tony Li >
Not if you do #5 (Insert row/column) first; the data get pasted into the new (inserted) row/column because it is still selected from #3 (the actual row/column you selected in #3 gets moved down/right and the new row/column acquires the focus i.e. becomes the selected row/column (it also acquires the row/column number/letter of the moved row/column). > > -----Original Message----- > From: Harold Fuchs [mailto:hwfa.openoff...@googlemail.com] > Sent: Monday, October 19, 2009 4:55 PM > To: users@openoffice.org > Subject: Re: [users] How to insert cut cells in Cacl > > 2009/10/19 Tony Li <tony...@viscountchina.com> > > > Dears, could somebody give the tips on how to insert cut cells in cacl, > > > > > > > > My requirement is: > > > > 1) Select on row / column in cacl, and click cut > > > > 2) Insert the cut row / column to another place like between column A > > and column B without overwriting the content in column B. > > > > > > 1. Select the row/column > 2. Edit>Cut (or Right click>Cut) > 3. Select the row/column *before which* the data are to go > 4. Right click the selected row/column > 5. Insert Row/column > 6. Edit>Paste (or Right click>Paste) > > Note that step #2 cuts the data but does not remove the column/row. That > would need an extra step. > > > > -- > Harold Fuchs > London, England > Please reply *only* to users@openoffice.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > -- Harold Fuchs London, England Please reply *only* to users@openoffice.org